Week 9

Milestones

• Modified "users vs median sync time for past week" table to "weekly median sync-time" table. This now shows weekly data for past 3 months
• Added condition in the above table according to sync_source i.e. different types of sync.

Screenshots / Videos

• Modified "weekly median sync-time" table

Contributions

• PR for frontend changes :
  • https://github.com/avniproject/avni-canned-reports/pull/12
• Commit:
  • https://github.com/ak2502/c4gt-milestones/tree/latest

Learnings

• Learned about incorporating different graphs and their parameters in Nivo mainly Line and Bar graphs
• Writing queries by incorporating date filter into them
• Learned new sql functions for handling series related queries like generate_series and data_trunc