Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a table like this
Time | Info |
---|---|
00 | 5 |
01 | 7 |
02 | 8 |
03 | 9 |
... | ... |
23 | 14 |
24 | 5 |
from 00 hours to 24, and it works as expected in my graph, but i need to limit the dimensions (Time in this case) just to show the data from the 07 hours to 16 hours
how can i limit this range?
Thanks for the help and sorry for my english, hope you can understand
in a straight table
with a calculated dimension
=if(Time >= 7/24 and Time <= 16/24, time(Time ))
sorry lol from 00 to 23
in a straight table
with a calculated dimension
=if(Time >= 7/24 and Time <= 16/24, time(Time ))
Are you looking for something like this
Hi,
=if(num(Time)>=7 and num(Time)<=16,'7 TO 16','OTHERS')
this one helped me, i had to do some modifications but it works! Thanks