Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limit a dimension to just show the hours i want

Hi, i have a table like this

Time
Info
005
017
028
039
......
2314
245

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

in a straight table

with a calculated dimension

=if(Time >= 7/24 and Time <= 16/24, time(Time ))

View solution in original post

5 Replies
Not applicable
Author

sorry lol from 00 to 23

maxgro
MVP
MVP

in a straight table

with a calculated dimension

=if(Time >= 7/24 and Time <= 16/24, time(Time ))

neelamsaroha157
Specialist II
Specialist II

Are you looking for something like this

el_aprendiz111
Specialist
Specialist

Hi,

=if(num(Time)>=7 and num(Time)<=16,'7 TO 16','OTHERS')

Not applicable
Author

this one helped me, i had to do some modifications but it works! Thanks