Hi All,
We need to show the TL wise Action view, refer the below table as a sample. Either we can give the same view as output or any other better view they expect from us.
|
TL field as filter |
|
|
KPI's |
Action Item |
Group |
Level Type |
'A' KPI |
XX Type - L1 level details
ID, ProcessName,ETA
Non - L1 level
ID,ProcessName,ETA
YY Type -
L1 level details
ID, ProcessName,ETA
Non - L1 level
ID,ProcessName,ETA
|
Company1 |
L1 |
'B' KPI |
(ID, Top 5 Process values, Process name, ETA) |
Company1 |
L2 |
'C' KPI |
Missing Process count based to show all (ID,ProcessName,ETA) |
Company2 |
L1 |
This is sample, we need to develop for N number of KPI's. Here, each KPI is different measures. Group and level types are dimensions. Action column: based on KPI's value, we need to highlight the Action ID lists.
Kindly let me know your idea, how to show this in Qlik Sense?