What I am trying to accomplish seems simple, but I cannot figure it out. Please help.
I would like to show in a KPI Comparison Widget:
Number of Meetings (CRM) Held in Last 30 Days compared to Number of Meetings Held the previous 30 days (from the date 30 days before the date that was 30 days ago).
Example:
Latest 30 Days Meetings Held (15-September 2022 [today] to 17-August 2022) = 15 meetings
Compared to
Previous 30 Days Meetings Held (16-August 2022 to 18-July 2022) = 11 meetings
I know Data Column would be (Meeting) ID = Count
But, I don't understand what I would use in the "Group By" since it only gives relative periods (full date, month/year, year, etc).
How do I do this?