cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying Monthly Changes

Jack_Machesky
9 - Travel Pro
9 - Travel Pro

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!

1 ACCEPTED SOLUTION

Miasm1
8 - Cloud Apps
8 - Cloud Apps

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!

View solution in original post

3 REPLIES 3

vshen
Sisense Team Member
Sisense Team Member

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
8 - Cloud Apps
8 - Cloud Apps

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
8 - Cloud Apps
8 - Cloud Apps

Thanks for sharing useful information