topic Re: Chart not taking into account a filter in App Development

Chart not taking into account a filter

jerryr125 — Mon, 10 Jun 2019 18:55:57 GMT

HI - can you somehow set a chart not to take into account a filter ?

I am displaying the AMOUNT on a table by particular dimension and I DO NOT want the AMOUNT to change based upon the filtering criteria.

Thoughts ? Jerry

Re: Chart not taking into account a filter

dplr-rn — Mon, 10 Jun 2019 19:01:15 GMT

Use set analysis to ignore a filter e.g. to ignore any selections of filter country
sum({<Country=>} Sales)

Re: Chart not taking into account a filter

dplr-rn — Mon, 10 Jun 2019 19:01:59 GMT

If you want it to ignore all filters
Sum({1} Sales)

Re: Chart not taking into account a filter

jerryr125 — Mon, 10 Jun 2019 19:22:46 GMT

close - how do I lock the date range ? that is - the date range does not take into account the filtered date range.

Re: Chart not taking into account a filter

dplr-rn — Mon, 10 Jun 2019 20:01:02 GMT

Put the date range in the set analysis. it will lock to those dates.
e.g. sum of sales last 6 months
Sum( {<OrderDate={"<=$(=today()) >=$(=MonthStart(Addmonths(today(),-6)))"}>} LineSalesAmount)

Re: Chart not taking into account a filter

Channa — Tue, 11 Jun 2019 01:11:00 GMT

=sum ( {<criteria= >} Amount)