flag on set analysis

[everest226]

HI i have MTDFlag for months and Daily.

and i have text object with the set analysis with following expression , i only want to change that object outcome when only selecting months but not by daily.

"count({<Date={'$(vExtractDate)'}, [ED Info.Event Type]={106}, WeekDay=, _HolidayFlag=>} Distinct [ED Info.Event ID])"

avinashelite‌

stalwar1‌

[rubenmarin]

Hi, not sure to understand, maybe something with:

If(MTDFlag='MTD', count({<Date={'$(vExtractDate)'}, [ED Info.Event Type]={106}, WeekDay=, _HolidayFlag=>} Distinct [ED Info.Event ID]), [Else_Expression])

  ,

[Digvijay_Singh]

May be something this -

"count({<Date={'$(vExtractDate)'}, [ED Info.Event Type]={106}, MTDFlag=P({<MTDFlag={'MTD'}>}),WeekDay=, _HolidayFlag=>} Distinct [ED Info.Event ID])"