Hi all,
I was trying to create a gauge chart using trellis container. But currently the values are not showing as per expectation.
![Test101_1-1589897286077.png Test101_1-1589897286077.png](https://community.qlik.com/t5/image/serverpage/image-id/33951i1FD91FD2AF21D588/image-size/medium?v=v2&px=400)
here as can be seen the achievement total is way more than each of the component. To cross check I added bar graphs to check for the same.
![Test101_2-1589897346536.png Test101_2-1589897346536.png](https://community.qlik.com/t5/image/serverpage/image-id/33952i8D09C75F18913641/image-size/medium?v=v2&px=400)
Here the correct value of achievement is shown for the bar charts.
I was thus wondering what I could be doing wrong with the gauge chart as I have followed the same process for both. Here achievement is just a ratio of total sales/total target
EDIT 1 : So I found that the Gauge chart has been averaging the achievement across all the categories. That's why I have been getting such low values. Can anyone help on how to get rid of this ?
Shouldn't a single row be shown instead of 3 in the table ? Also I tried the same example with other sub products and rather than showing a single aggregated row, multiple rows based on product categories were shown.
![Test101_0-1589899232601.png Test101_0-1589899232601.png](https://community.qlik.com/t5/image/serverpage/image-id/33954iBD77FCBD87E003C2/image-size/medium?v=v2&px=400)