Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have dashboard with 3 sheets that is rotating tabs after a minutes but when i plug it in my access point it doesn't rotate like it is on my PC i have to click refresh manually to rotate tabs.
I used this condition to rotate my tabs =(((now()*24 * 60) - floor((now()*24 * 60)) ) * 60 / 10) < 1 which works fine but on my PC not in access point.
Thanks
sorry
cretaed 3 variables
i have 5 sheets so i i habe kep
t vSheets=5
vDelay= for every 2 minutes the tab will rotate to other tab so vDelay=120
and
vShow==ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets))
and in the sheet properties we can keep as vSheet=1( for first tab),vSheet=2( for Second tab),....vSheet=5( for fifth tab)
In fact, Now() won't work in Access point / Web view. So, That is the bug where i got the information.
Hi Anil
Thanks what can be my solution?
Regards
hi philip,
i have 5 sheets which rotates every 2 minutes
i have cretaed a variable
=ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets)) and
in every sheet property
for sheet5, we can keep as vShow=5
for sheet4 , vShow=4
sorry
cretaed 3 variables
i have 5 sheets so i i habe kep
t vSheets=5
vDelay= for every 2 minutes the tab will rotate to other tab so vDelay=120
and
vShow==ceil((frac(now())*86400/(vSheets*vDelay)-floor(frac(now())*86400/(vSheets*vDelay)))*(vSheets))
and in the sheet properties we can keep as vSheet=1( for first tab),vSheet=2( for Second tab),....vSheet=5( for fifth tab)
Hi Sahaja
Please correct me cause it seems not to work.
Thanks
Hi Sahaja
Any luck?
Thanks
Hi
PFA qvw.
In Sheet conditional used Variable vShow instead of vSheets.
Thanks
Hi Sristi,
Thanks for your help,but i doesn't rotate in my Access point like it is on my PC i have to click refresh manually to rotate tabs.mybe i am missing something.
Thanks
If you plan to use this dashboard on a (large) display screen, maybe you can use the IE-plugin as a client? Just for this screen?