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...
  • Sportily's avatar
    Sportily
    Frequent Visitor
    3 years ago

    Hi,
    Thanks for the reply.

    Nice to know if may be possible. Although I'm not sure I know what to do from your description.
    For the conditional formatting I apply this using the tool in each value displayed in the table.

    I've mocked this up in Excel showing the COUNTIF based on the AVERAGE figues displayed in a table, filtered from a dataset.
    Here : shorturl.at/aftU4

     

    Thanks so much

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper 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