Excluding a single field in Set analysis from being affected by a filter pane

[alex-wb]

Hi,

In my app I used date filter panes to restrict time periods selected, however in my below set analysis I need the filter pane to apply on all fields bar one which is  a variable called vFY_Year_Start. For example if I wanted to look at last week I would want my max date to be 31/10/2021 but my FY_Year_Start to ignore the start of last week and capture all faults raised from the start of the year up to the selected date. 

Count(TOTAL{<
FAULT_CLOSED_DAY=-{""},
FAULT_CLOSED_DAY={">=$(vFY_Year_Start)<=$(vFY_Year_End)"},
PRODUCT = {'ETHERNET'},
SERVICE_AFFECTING ={'Y'}
>}
FAULT_REF)

Thanks for the help. 

[BenjaminT]

Hi,

Is the problem that vFY_Year_Start is changing when you make selections in the filter panes? If so, what is your expression for vFY_Year_Start?

Thanks

Ben

[alex-wb]

Yes, that's what I would like to remain static. It's written off of an expression based on a unique calendar year.

let vFY_Year_Start = WEEKSTART(YEARSTART(Monthstart(today()),0,4),0, 5)

[BenjaminT]

I'm not sure I've understood but if you want your expression to ignore a filter on a particular field or fields, you can add those fields to the set analysis with no specified value:

Count(TOTAL{<
FAULT_CLOSED_DAY=-{""},
FAULT_CLOSED_DAY={">=$(vFY_Year_Start)<=$(vFY_Year_End)"},
PRODUCT = {'ETHERNET'},
SERVICE_AFFECTING ={'Y'},
DATE_FIELD_1=,
DATE_FIELD_2=
>}
FAULT_REF)

Hope this might help

Ben