Displaying Monthly Changes

[Jack_Machesky]

Hello, I was wondering if anyone had any ideas on how to save monthly instances of certain widgets, with their values. I have three widgets that are queried every night, and their values change accordingly. The dashboard that these widgets live on, however, is rolled out on a monthly basis. I was wondering if there was a way to store the monthly values of these widgets and be able to see what they previously were if I filter the dashboard by month. Thank you for any help and input!

[vshen]

Hi Jack,

Why wouldn't a Date filter be suitable for this? I.e., if you want to see the data for the past period, you set the date filter to that period.

However, if you mean to display data that was at some point in the Model but got deleted and you would like to show the state of the widget when that data was still present, then it is not possible, I'm afraid.

[Miasm1 · Accepted solution]

Hi there,

To save monthly widget values:

1. Use a database or files.
2. Record values and timestamp nightly.
3. Create a structure for data.
4. Retrieve past values by filtering timestamps.
5. Update dashboard for monthly view.

https://community.sisense.com/t5/developer-forum/displaying-monthly-changes/snowflake trainingtd-p/18993 

Hope this helps!

[marcoperson250]

Thanks for sharing useful information