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]

Take today() in variable and try..

= if(1/6/2014=$(vToday),1)

vToday is Today()

And also check the date format....

Selva...

[simondachstr]

Day() formats to numbers 1-7. Maybe your day field though are characters 'Mo', 'Tue' etc.?

A small but very common error.

[preminqlik]

hi try this

count(if(Date=date(today()),Number))

hope this helps you

[preminqlik]

or count({{<Date={'$(=date(today()))'}>}Number)

[#6]

Hi,

  Days field contains 1 to  31 numbers only not in text format

[adnan_rafiq]

if you use Date(Today) it will return value like 1/6/2013 which will be re evaluated to 1 divided by 6 divided by 2013 due to $ expansion (you can say it a bug). Use num(Today() and make sure in script you load DateField as number

by using num(DateField) as DateField

[Anonymous]

Create the numeric value of your date field in script to ignore any format issues.

via, num(Date_field) as Date_field_num.

Now use this field in expression in set analysis

count({$<Date_field_num={$(=num(today()))}>}Number)

Hope it solves the problem...

Regards

Nitin

[jagan]

Hi,

Can you attach some sample file.

Regards,

Jagan.

[#10]

Hi,

   PFA

Regards

Divya