Hi, I am new with Qlik Sense. I am trying to use the average function and is not working. Here is what I want to do:
I have a table with KPI information in one column and the data per month in the other columns, example:
KPI | Jan-2016 | Feb-2016 | Mar-2016 |
---|
1. Number of Claims | 2 | 4 | 5 |
2. % of past due Claims vs. Open Claims | 10% | 8% | 12% |
| | | |
So, technically, the KPI 1 should be 3.66 and the KPI 2 should be 10%. Is there anyway to do it in the same Gauge?