Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hey i have a problem
im using a simple graphic table and i want to paint each row depending a validation, im using this tables
FACT:
LOAD "ID_DOCUMENT",
"ID_PROCESS",
"ID_PRODUCT",
"S_TIME_AVG"
FROM FACTS_Docs.QVD (qvd);
Document:
LOAD DOCUMENT,
"ID_DOCUMENT",
"ID_PAIS",
SLA
FROM DimDocument.QVD (qvd);
and i need to compared if SLA is <= AVG(S_TIME_AVG) then paint red else paint red each row
i don know witch control or what i have to do to get this
thanks
Pablo Cifuentes
Go to the Dimension or Expression Tab (depending on what aspects to the row you want to highlight)
Expand the + sign, select Backgound Color and select Edit
in the expression type
=if(SLA<= AVG(S_TIME_AVG), DarkGray(), Blue())