Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Team,
Pivot Table is showing the data in qliksense in all the cells it is showing zero values please find the attachment for refernece also find the KPI Formula below
Formula:
num(sum(aggr(max({$<[Service Type]={'S01'},[C Code]-={'ZY'},[R Ticket num]={0}>}[RC Days]),[Ticket ID]))/(count(distinct{$<[ Service Type]={'S01'},[C Code]={'Z1','Z2'},[ZCSRQ_TID__ZUPDATE]-={'Y'},[Re Ticket num]={0}>}[Ticket ID])),'##.##')