Color by expression

[vbravomo]

Hi guys,

Please I need you so much.

I have to créate a table with two columns: e-mail and calls (count(document))

And I have to put colors to  calls > avg (calls).

I've used this code, but it doesn't work. It returns the same color in all rows

if(count(Document)<avg(aggr(count(Document),[email])),blue(),red())

Thanks 🙂

[Frank_Hartmann]

Maybe this:

if(aggr(count(Document),[email])<avg(aggr(count(Document),[email])),blue(),red())

[vbravomo]

Thanks, but it doesn't work. It returns me one color in all raws.

I really don't need the email, but the aggr needs a dimensión.

Should I create a count(document) value  in the script?

[Frank_Hartmann]

can uyou share a sample qvw which demonstrates the issue?

[vbravomo]

[vbravomo]

I've added an xlsx, just in case.

Thnks

[vbravomo · Accepted solution]

Thank you.

It Works! The new code is:

if(count(Documento)<(avg(Total aggr(count(Documento),[Correo electrónico]))),blue(),green())

[Frank_Hartmann]

try this:

If(count(Documento)<avg(Total aggr(count( Documento),[Correo electrónico])),blue(),red())

[WilsonMadureira]

No KPI quando meto um numero nesta parte eu escolho meter um Titulo. Nesta parte poderei escolher a cor em vermelho como titulo?

Porque consigo por apenas em cinzento.