Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have straight table with RAG status created.
Is it possible for to show Count of each Red, Amber and Green separately as summary on the table using buttons/text?
Using this expression for background in table -
if((sum(Aggr(count(DISTINCT{<ADG_Flag={1}>} [User ID]),[Creator Created Date Time]))-sum(Aggr(Count(DISTINCT {<DB_Flag={1}>} [User ID]),[Creator Created Date Time])))/
sum(Aggr(count(DISTINCT{<ADG_Flag={1}>} [User ID]),[Creator Created Date Time])) >=0.75,'#DB2001',
if((sum(Aggr(count(DISTINCT{<ADG_Flag={1}>} [User ID]),[Creator Created Date Time]))-sum(Aggr(Count(DISTINCT {<DB_Flag={1}>} [User ID]),[Creator Created Date Time])))/
sum(Aggr(count(DISTINCT{<ADG_Flag={1}>} [User ID]),[Creator Created Date Time]))<0.25,'#008580','#e8a215'))
Regards,
Richard
I was able to achieve counts myself, example shared for Red count -
Count(distinct aggr(if((Count({<ADG_Flag={1}>}DISTINCT [Process Reference])-Count(DISTINCT{<DB_Flag={1}>} [User ID]))/Count({<ADG_Flag={1}>}DISTINCT [Process Reference]) >=0.75,[User ID]),[User ID]))
I was able to achieve counts myself, example shared for Red count -
Count(distinct aggr(if((Count({<ADG_Flag={1}>}DISTINCT [Process Reference])-Count(DISTINCT{<DB_Flag={1}>} [User ID]))/Count({<ADG_Flag={1}>}DISTINCT [Process Reference]) >=0.75,[User ID]),[User ID]))