Dashboard Auto-Refresh

Question & Answer
, ,
1

Hello,

I am having problems with implementing auto-refresh embedded dashboard logic. and previously this was discussed with @DylanM on other ticket (Auto-refresh embedded dashboards - #15 by harpar1808).

I have attached latest errors and code there. Can someone please assist at the earliest since this is a critical issue for us.

Thank you for your help.

1 Like
2

Hello @harpar1808, see the response I posted on this topic. Let me know if that helps! If not, include your findings on this topic rather than the older one so I can track it appropriately.

Thank you!

3

Hello,

Thank you for responding. That still didnt work. I was sending updates every 30 seconds only to see that it is refreshing (even though the data might still be the same). However, I kept it to go on past 15 mins and still no refresh happening. The data is as of 12PM only … however it should have more data if it actually refreshed.

image
image586Ă—532 71.4 KB

4

Hello @harpar1808, I have one more thought on this, and I can try testing a few other things on my end as well. Let’s try actually connecting the parameter to the data in some way to see if it would force a refresh.

What if you passed in an end date parameter that would just filter the data to the timestamp of the refresh. That shouldn’t impact the data that is being displayed, but then will hopefully be enough of a change to guarantee the visuals receive the updated data. Also, can you just double check for me as well that your dataset is actually bringing in more rows of data once the refresh is completed?

I figure that it isn’t a dataset issue, but it doesn’t hurt to confirm that the refresh is working as expected.

5

Hello @DylanM ,

Yes so it worked actually when I put a fake filter on that RefreshParam parameter and attached it to a sheet. So far so good. Couple more questions:

  1. I have dashboards with multiple tabs (sheets) and if I attach this fake filter to a particular visual, will it refresh entire dashboard with all the sheets/visuals etc ?
  2. What happens when there are scheduled dashboards report runs to be run ? Do I need to kick off a refresh before that too ?
  3. If multiple people load this dashboard, that means there are multiple refreshes happening.. that should be okay load-wise right?
1 Like
6

Hello @harpar1808, I am glad that worked!

I can try to answer your remaining questions:

  1. Yes, the refresh isn’t limited to a single visual, rather the entire dashboard will update.
  2. The reports should be based off the latest data at the time they are scheduled to run. This shouldn’t require any kind of manual update to manage this feature.
  3. This shouldn’t have any impact on performance. It is basically the same functionality if a user refreshed the page. Since the data is in SPICE, there is nothing about this feature that should change the dashboard load times.
7

Thanks @DylanM ,

Few more questions:

  1. If a refresh is going on, and I fire another SetParameters call, will that start another parallel refresh? Is there any API call that I can use to check if refresh is going on or do I need to handle myself ?

Thank you.

1 Like
8

Hello @harpar1808, the SetParameters call isn’t requesting a dataset refresh but rather a dashboard refresh. If the call to reset the parameter is done before the dataset refresh is completed, then the data will look the same. It needs to wait for the dataset to be refreshed until the parameter should be sent.

You could always run the describe-data-set API call to retrieve the last updated time. This would allow you to know the refresh has occurred before sending the new parameter value.