Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For a client I have to build an online dashboard. One of the requirements of the dashboard is that curtain selections in a list box change after 15 seconds. The client must also be able to pause the auto change and to resume the auto change.
I already found out how to change a chart every 15 seconds. I did this by making five seperate graphs with an condtional show.
This is not sufficient because the selection has to change every 15 seconds and with it the charts. Beneath is the code I used to the make the charts change.
Timing:
LOAD
Seconds
,rangesum(peek(PrevSumSeconds),peek(Seconds)) as PrevSumSeconds
INLINE [
Seconds
15
15
15
15
15
];
SET vSeconds = mod(round((now()-now(2))*86400),sum(Seconds));
The condtion for the charts are
floor(vSeconds /15)=0, floor(vSeconds /15)=1, floor(vSeconds /15)=2, floor(vSeconds /15)=3, floor(vSeconds /15)=4, floor(vSeconds /15)=5
Basicly I have three questions to be answered.
First, how do I make a list box change the selection every 15 seconds (instead of a chart)?
Second, how do I pause the auto change of the list box?
Third how do I resume the auto change of the list box?
Hi frank,
Did you found any solution on this..I have the same requirements..
Best regards,
Nikolaos Kavroulakis
Hey Nikolaos,
I managed to get it work. I think I did itby creating a second sheet which is conditionally shown when the pause button was pressed.
If you need any help, let me know.
gr.
Frank