set Analysis

[#1]

Hi everyone,

               I have to display data on hourly basis .Ihave taken hours as dimension and Expression is

=if(day=day(today()),count(number)) it is not working

if day is today then i should  count Ticket number and show the data.Please help me

Regards,

Divya

[#2]

Hi,

    I tried it is not working .help me

Regards,

Divya

[#3]

Hi

Your application is failed to open can you attach the same one more time

[#4]

hi ,

reattaching ... PFA

[jagan · Accepted solution]

Hi,

In your script replace this

Timestamp(opened_at,'hh') as Hours with Hour(opened_at) as Hours

and in your variable set Vtoday =today() and use this expression in chart

=count({<date={'$(Vtoday)'}>}number)

Regards,

Jagan.

[MK_QSL]

Try this...

=Count({<date = {"$(=Date(Today()))"}>}number)

[#7]

Hi Manish I tried it is not working

[MK_QSL]

What is the total count number for today... I have used the same and getting answer

[manideep78]

Hi Divya,

Please try the below expression

=Count(If(day(Today()),number))

[#10]

Hi,it is working.Thank you