Rolling 12 months based off a end month date filter
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?
courtneyjessop
Posted 2 years ago·Last reply 2 years ago
3 comments
courtneyjessop
OP2 years agoI tried the widget script listed the first one and it didn't work. the BloX option is for preset dates (current month, last month, so on). the second one you list does not change if the user changes the dashboard filter.
DRay
·2 years agoHello courtneyjessop,
Thank you for reaching out.
I found a few related posts that may help.
https://community.sisense.com/t5/build-analytics/how-can-we-show-previous-12-month-on-selecting-a-particular/td-p/5007
https://community.sisense.com/t5/knowledge/show-the-data-for-this-and-last-year-but-not-the-current-month/ta-p/21180
Can you let me know if they provide the solution you are looking for?
Thank you, and have a great day!
courtneyjessop
OP2 years agoI tried the widget script listed the first one and it didn't work. the BloX option is for preset dates (current month, last month, so on). the second one you list does not change if the user changes the dashboard filter.