topic Re: Filter on a Dimension - do not allow the filter to effect the chart in App Development

Filter on a Dimension - do not allow the filter to effect the chart

jerryr125 — Fri, 07 Aug 2020 13:45:03 GMT

Hi - I have a sheet with a couple of different charts (Dimension = Status Date).

I add a filter to sheet to filter on Status Date (for another formula).

What if I DO NOT want the filter to effect the charts on my sheet ? how can I do this ? Jerry

Anil_Babu_Samineni — Fri, 07 Aug 2020 13:53:32 GMT

There are many options you can choose

1) Alternate States

2) Restricting the filter filed in set expression

jerryr125 — Fri, 07 Aug 2020 14:18:12 GMT

HI - I am not following your recommendation clearly - can you provide an example ?

Anil_Babu_Samineni — Fri, 07 Aug 2020 16:31:07 GMT

Instead start in google with key words provided? And also, You can create one sample and ask us to help instead asking from scratch.

jerryr125 — Fri, 07 Aug 2020 18:29:37 GMT

Hi - thanks for your help!

Ok I have a dimension that is a date (say statusdate).

I would like to have a filter on the sheet for statusdate but not filter out two of charts that are related to statusdate.

I don't mind if the other charts filter on statusdate, but two of the are charts are required not too.

Thoughts ? jerry