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.
