Skip to Content
author's profile photo Former Member
Former Member

Simultaneous Refresh of Xcelsius Dashboard


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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2011 at 12:10 PM

    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


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      follow the link to caputre current time

      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.


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.