topic Re: Excluding a single field in Set analysis from being affected by a filter pane in App Development

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

alex-wb — Mon, 01 Nov 2021 12:10:32 GMT

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.

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

BenjaminT — Mon, 01 Nov 2021 13:30:59 GMT

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

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

alex-wb — Mon, 01 Nov 2021 14:29:06 GMT

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)

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

BenjaminT — Wed, 03 Nov 2021 21:16:46 GMT

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