Count of RAG from Qliksense table

[richard24best]

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

[richard24best · Accepted solution]

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]))