Set Analysis in Date Dimension

[#1]

Is it possible to put a set modifier in a date dimension?

i.e. date({$<Step={4}>} Date, 'MM-DD-YY')

An order can go through many steps, but i want all of the order's information to report on the date that step 4 occurs.

My problem occurs when I'm doing a stacked graph comparing the data of each step, so data that occurs on step 5 reports on the date of step 5, not step 4.

Please help!

[kaushiknsolanki]

Hi,

   Set Analysis is not possible in date function.

   If you can give us full detail of your problem with description and the sample file, that would make it easier for us to understand and solve your problem.

Regards,

Kaushik Solanki

[Anonymous · Accepted solution]

Set works only with aggregation functions.  Your can use
only({$<Step={4}>} Date)
or, if you have to use formatting
date(only({$<Step={4}>} Date), 'MM-DD-YY')