How to write expression in Set Analysis

[#1]

Hi,

I have to show in line chart curent month employess and the dimension is Day of Month.

Can anyone help me how to write with set analysis as when i am using one dimesion as Month and other dimension as Day and expressions as Count(Distinct(EmployeeID) it is not showing correct values. please help.

Thanks.

[#2]

If you have Dimensions:

- Month

- Day

And Expression: =count(distinct EmployeeID)

You can change your expression into: =count( TOTAL <Month> Distinct EmployeeID)

This will allow your expression to skip being filtered by all the chart dimensions but Month.

[jagan]

HI,

Try like this

Dimension : Day(DateDimension)

Expression : Count({<Day=, Week=, DateDimension={'>=$(=MonthStart(Max(DateDimension)))<=$(=Max(DateDimension))'}>} EmployeeID)

Hope this helps you.

Regadrs,

Jagan.

[#4]

Thanks and you mean DateDimension means Date and if I want to have MonthSort also as dimension means how can I write?

[jagan]

Hi,

Yes, replace DateDimension with your date field and MonthStart is a function.  Can you attach some sample data?

Regards,

Jagan.