topic Re: Filtering data from a chart in App Development

Filtering data from a chart

mrmatt — Wed, 11 Dec 2019 19:51:15 GMT

Hello, is there a way to filter certain data from a dimension in a chart I've created? I know it would be hard coded but that's ok.

Appreciate your help.

Re: Filtering data from a chart

Vegar — Wed, 11 Dec 2019 21:23:41 GMT

You can filter your charts by using set analysis in your expressions.

Let's say you want to only calculate sales for the northern region in 2019 you can do like this.

SUM({< Region={'Northern'}, Year={2019}>}[Sales amount])

Re: Filtering data from a chart

mrmatt — Thu, 12 Dec 2019 14:24:41 GMT

@Vegar thanks I'm actually not doing a sum query. I'm trying to exclude a certain data value from a string field. How does this look to you? It's giving me an Invalid Dimension error:

=maxstring({$<FieldName={"data name"}>}FieldName)

Re: Filtering data from a chart

Kushal_Chawda — Thu, 12 Dec 2019 14:32:36 GMT

try this

=aggr(maxstring({$<FieldName={"data name"}>}FieldName),FieldName)

Re: Filtering data from a chart

mrmatt — Thu, 12 Dec 2019 14:59:35 GMT

@Kushal_Chawda that worked great. I just had to add the minus to actually exclude that single data string.

=aggr(maxstring({$<FieldName= - {"data name"}>}FieldName),FieldName)