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:
|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?