Forum Discussion

Sriku's avatar
Sriku
Icon for Helper IV rankHelper IV
6 years ago

Bucket matrics and create RAG status

Hi Team,   Need to count the total metrics and the total bucket as Red >0 and Green =0: Country Metrics1 Metrics1 Metrics1 Metrics1 Total CA 0 0 0 0 0 OR 0 1 1 0 2 W...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Sriku , how come are Metrics has the same name Metrics1

 

You can create a new measure

 

Total = sumx(Table,[Metrics1] +[Metrics2]+[Metrics3]+[Metrics4])