topic Re: how to ignore 1 filter value, but keep other 3 filter? in App Development

how to ignore 1 filter value, but keep other 3 filter?

jiaqi — Fri, 15 Nov 2024 20:54:55 GMT

I have an app, 1st sheet has 4 filters: year, month, type, department. after I selected filters, sheet 1 will jump to sheet 2 , and keep all the filters. and I want to have a line chart to show the score changes by year.

but year has selected at the beginning, so the line chart cannot show the X ray with full year. the other 3 filter must keep, then I will set avg of score.

the question is: how can I skip the year filter, and keep others, calculate the avg with the other 3 filters.

besides, the ray may be year, may be month, depends on the type filtered. could it be possible to change automatically?

Re: how to ignore 1 filter value, but keep other 3 filter?

Lisa_P — Mon, 15 Jul 2024 22:30:49 GMT

In the avg of score measure you can tell it to ignore the year filter using set analysis.

Just place the Set analysis in front of the avg expression like this:

{<Year>}Avg(score)

Re: how to ignore 1 filter value, but keep other 3 filter?

M_B — Tue, 16 Jul 2024 13:11:54 GMT

Avg({1 < Filter1 = p(Filter1), Filter2 = p(Filter2), Filter3 = p(FieldFilter3)>} MeasureField)

{1} ignores all filters

The fields are the ones you want to keep so you can make an exception for those.

It basically reads: Ignore all filter except this, this and this.

Re: how to ignore 1 filter value, but keep other 3 filter?

jiaqi — Tue, 23 Jul 2024 08:56:32 GMT

thanks, but not working, maybe it should be {}Avg(score)

Re: how to ignore 1 filter value, but keep other 3 filter?

ali_hijazi — Tue, 23 Jul 2024 11:44:04 GMT

no the syntax is correct but the field or column year is it defined as such; I mean the column names are case sensitive

if your field is named YEAR then the syntax would be

{<YEAR>}
avg(Score)

Re: how to ignore 1 filter value, but keep other 3 filter?

jelisjack4 — Tue, 23 Jul 2024 21:52:49 GMT

To achieve this, you can adjust your filtering logic so that the year filter is excluded when calculating averages.

Ignore the Year Filter: In your app's logic, apply the other three filters (month, type, department) while excluding the year filter when calculating the average score business 2.
Dynamic X-Axis: For the line chart, you can set the X-axis to dynamically adjust based on the selected filter type. This way, if the year is selected initially, the X-axis will show full-year data. If a different filter (like month) is selected, the X-axis updates accordingly.

You might need to configure these settings in your app or data visualization tool’s filter and chart options.