topic Re: Embed Filter into Chart in App Development

Embed Filter into Chart

JamesR — Mon, 20 May 2019 15:34:53 GMT

I'm trying to embed filters into bar charts and I can't seem to figure out which syntax is will work for this. It seems a fairly easy task.

Trying to show 2, side by side bar charts one showing open sales pipeline, and one showing a closed won status.

For both charts, the Dim is Region, and the Measure is TotalPrice.

I have tried so far based on searching:

Sum(if(StageName='Closed Won', TotalPrice))

If(StageName='Closed Won', Sum(TotalPrice))

The first option returns everything in the table, so its' not checking the If correctly.

The second one returns nothing at all.

Maybe I'm trying to over-simplify this.

Re: Embed Filter into Chart

Lisa_P — Tue, 21 May 2019 03:49:39 GMT

We can filter our data using Set Analysis. For your scenario, the Measures will be:
Sales Pipeline
Sum({<StageName=-{'Closed Won'}>}TotalPrice)
Closed Won
Sum({<StageName={'Closed Won'}>}TotalPrice)

Re: Embed Filter into Chart

JamesR — Wed, 22 May 2019 11:36:22 GMT

Thank you! I will give that a try.