The view i am trying to create is you have a MTD count,
FYI-for both of these the dimesions are User and application name also i am performing this in a pivot table.
MTD utilization count- how many times so far does the user performed a session(count of days) as an example i will asume as today is 21st so out 21 days in this month 10 days the user performed a session(doesnt matter about number of sessions on same day).
Does this expression makes sense for the above condition as i being skeptical about it?
=count({$<Date={">=$(=(MonthStart(Max(Date))))<=$(=(Date(today(01/31/2013)-1)))"},[Session Start]={"*"}>}DISTINCT Day)
MTD actual -how many days is it so far in month(lets just say until today its 20 days and it should be dynamic with the selection between different months and years) ALSO the # days are including all the days at this point it doesn't matter if its a non businessday we still consider.
What should be my condition to show just the numbers days passed so far in this month(MTD)?
