Simultaneous Refresh of Xcelsius Dashboard

[Former Member]

Hi,

My dashboard is set to refresh before load and then refresh after every 10 min and its working fine.

Dashboard is used by many users and they recently noticed that data on different users dashboard are not same same. After investigation I found that 10 min periodic refresh is based on time after user open his dashboard so data may differ in different dashboard opened at different time.

Is there any way to sync up refresh time irrespective of dashboard open time. If we can set some periodic time on which all open dashboard refresh.

any example will be great.

Thanks In Advance

[Former Member · Accepted solution]

Hi ,

I have an idea..

in spread sheet use now() function to get current time

use minute () function to calculate minutes form current time cell

write a formula if mod of minute,10 =0 then 1 else 2.

now use this cell as trigger cell and enable IF THE VALUE is equal to 1 radio button

Logic : always the value of formula cell will change only if the modulas value is 0

so for every 10 min the value =1 and dashboard gets refeshed.

Note:loop the now() formula to update aslong as the dashboard is open

Check if this suites your requirement

@Sri

[Former Member · Accepted solution]

Hi Sri,

Thanks for your reply, I did exactly same steps as you mentioned in your reply before my post but got stuck when Now() value does not get updated in swf. To get around with that I used History component to keep updating now(). But again now() got delay at the load time. My dashboard refresh before load and take around 30-sec to 2 min to load that means all different user will have different now() value and can lag by few minutes.

Do you think of any better workaound where value of now() will be same for all user?

Kind Regards

Kumar

[Former Member · Accepted solution]

Raghav,

I think you should refresh the dash board only at certain intervals in a day like say every 2 hours. If the dashboard refreshes at 11AM 2PM and then 4PM constant times in a day, all the users will have the same data. because data refresed at 11AM is upto date by 11AM.

for triggering purposes use the formula like this

=if(hour(now())=11,1,if(hour(now())=13,1,if(hour(now())=15,1,0))). the cell with this formula has a 1 only at hours 11,13,15. the remaining time it is a 0. and trigger the dashboard only when this cell is 1

try it out for 10 minute interval but execute for contant hour times in a day

Thanks,

Karthik

[Former Member · Accepted solution]

Hi

follow the link to caputre current time

http://myxcelsius.com/2010/09/09/create-digital-clock-xcelsius/

Here play selector enshures continuous update of now().

Now use our formula if mod of minute,10 =0 then 1 else 2

now for the first time when the dashboard is opened ,as refresh before components is enabled

the dashboard gets refreshed and it is not dependent on now() so different users may not get the same data but after 10 min the dashboard gets refreshed accoring to trigger cell where it is dependent on now().so now ithink the users will get same data.

Try this.

@Sri