Rolling 12 months based off a end month date filter | Help and How-To

courtneyjessop · 2024-09-20T16:42:06.864000Z

I have monthly totals that i want to average and display on the dashboard. Once the user picks a End Month date we want the dashboard to display everything for the 12 month up to the end month date. If the date picked is 7/2024 it will show the records from 7/2024 to 8/2023 and only total that set even if there are more month before and after those dates. How should this be done built out?

MoreDiscussions

Rolling 12 months based off a end month date filter | Help and How-To | Sisense Community