Set Analysis Query in Gauge Chart

[#1]

Hi All,

I have a demo table like below. Now I have a list box that shows month based on KPIDate as Jan, Feb etc. I have taken a gauge chart and want to display a number (style LED format).

KPIDate	Claim_TTL	Count	Claim
201501	1	1	200
201501	0	1	300
201501	0	1	400
201501	1	1	500
201502	1	1	600
201502	1	1	700
201502	0	1	800
201502	0	1	900
201503	0	1	1000
201503	1	1	1100
201503	1	1	1200
201504	1	1	1300
201504	0	1	1400
201504	0	1	1500

I have a requirement to show count when a month is selected, only where Claim_TTL is 1. So if Jan is selected, then it should show the below

KPIDate	Claim_TTL	Count	Claim
201501	1	1	200
201501	1	1	500

I am writing this expression in the gauge chart expression

Sum({<Claim_TTL= {1}} Count)

But this always return 0. Can you please help me with this expression? Basically I want to show the count here which will be 2 in Jan case.

[eduardo_sommer · Accepted solution]

There is a > missing in your expression

Sum({<Claim_TTL= {1}>} Count)

Eduardo

[#3]

Thanks Eduardo. Fixed it.

Set Analysis has very confusing expression language.