TL wise Action view (table or Pivot or any other visual)
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?
