Forum Discussion

Sportily's avatar
Sportily
Frequent Visitor
3 years ago

COUNTIF based on Averages in displayed table

Hi TeamBI! Thanks SOOO much for looking at my question.   I have a visual - its a table. Each of the 7 columns in the visual table incldes a number between 0 -7. (Based on 7 columns in the datave...
lbendlin's avatar
lbendlin
Super User
3 years ago

Like this ?

Or do you want to count this across columns PLAN and EAT?  In that case you need to unpivot your data first.

Sportily's avatar
Sportily
Frequent Visitor
3 years ago

Thanks.

Yes,  The measure would be COUNTIF( Average of [Plan] and Average of [Eat],   >-4 )  

So it would deliver either 0, 1, 2 as the answers.

 

In your example Mark would be a 0 and Simon would be a 1.

 

The colour coding is achieved using conditional formatting and works fine currently. But I didnt know if there was a way to COUNTIF( cells in the row are background colour green ) as an alternative to counting the averages >-4.

 

Thanks for your interest.

Chris