Skip to content

Exec Dashboards PoC: Add Month-to-date (MTD) and calendar months to the comparative table MVC

Overview

Once Exec Dashboards: New page frontend POC with "Me... (#373006 - closed) is completed, we need to add the missing MVC features to the Exec Dashboards PoC.

Proposal

  1. Period 1 - Add a column for MTD (month-to-date).
  • Display the metrics values starting at the beginning of the current calendar month and ending at the current date. (e.g. 2022-10-01 --> 2022-10-18).
  • Column name - Month-to-date.
  1. Period 2 - Change the 'last 30 days' column to display the previous month metrics values.
  • Display the metric values starting at the first day of prev month and ending at the last day of prev month (e.g. 2022-09-01 --> 2022-09-30).
  • Column name - month_name (e.g. September).
  1. Period 3 - Change the '30 before that' column to display the previous before_month metrics values.
  • Display the metrics values starting at the first day of before_month and ending at the last day of before_month (e.g. 2022-08-01 --> 2022-08-31).
  • Column name - month_name (e.g. August).
Edited by Haim Snir