Yep, i need a hard-coded Elvis.
I want to create a Gauge per SalesManager.
My Dimension for the the first Elvis Gauge:
=SalesManager = 'Elvis'
The second Gauge will probably be MichaelJackson:
=SalesManager = 'MichaelJackson'
The Needle is in the right position, but i can't get the value in the 'Text in Chart'.
Using "sum(xSales)" doesn't do anything with my 'Elvis Dimension'.
Attached a simple example.
The real file has no possibility to select a different SalesManager.
The Gauge has a hardcoded Dimension =SalesManager = 'Elvis'.
What i'd like to achieve is to show 1000000 (sales by Elvis) as 'Text in Chart', instead of 2775500.
Gauge-test.qvw 125.5 K
Shouold be a simple solution:
Remove the dimension and enter the following as your Expression: =sum(if(SalesManager='Elvis',xSales))
Use the same with your 'Text in Chart' or even ='Elvis Sales: '&sum(if(SalesManager='Elvis',xSales))
That works in your example file and how I've used it in the past.
Hope that helps,