Show data by current time

[its_rajvir]

Dear Experts,

need your help to extract some data.

I have a table like this :

Hour	Sales
8 to 9	100
9 to 10	400
10 to 11	267
11 to 12	135
12 to 13	156
13 to 14	789

Now for example if the current time is from 9 to 10 it should only show that particular hour data not the other ones. then in the next run it should show next hour data on the dashboard.

[MayilVahanan · Accepted solution]

Hi

Try like below

LOAD * INLINE [
Hour, Sales
8 to 9, 100
9 to 10, 400
10 to 11, 267
11 to 12, 135
12 to 13 , 156
13 to 14, 789
]Where Trim(SubField(Hour,' ', 1)) = Hour(Now());

Might be, it helps or give idea 

[SchalkF]

Hi @MayilVahanan ,

I just took yours and used it in a visual instead of in the load.

I use the same clause as MayilVahanan just in an if statement in a chart.  Please see below screenshot: