Forum Discussion

Beiffon's avatar
Beiffon
Frequent Visitor
8 years ago

Not showing as average

HI All,

 

I have an issue where a column of numbers is not showing as an average.

 

Q1 Answer, Q2 Answer and Q3 Answer all all number.

 

Q1&2 both have the symbol but Q3 does not. Any idea why?

 

Thanks

Need Help

5 Replies

  • BalaVenuGopal's avatar
    BalaVenuGopal
    Icon for Resolver I rankResolver I
    8 years ago

    HI Beiffon ,

     

    One check is make sure datatype of the column is either Number or decimal should not be text.

     

    And you can create measure M1 = average(Column_Name).

     

    If above answers dint work for you please give some more information like data and columns so that we can help you

     

    Regards,

    Venu Gopal

    • Beiffon's avatar
      Beiffon
      Frequent Visitor
      8 years ago

      HI,

       

      They are set to numbers

      But its still showing as same after a refresh.

      • Beiffon's avatar
        Beiffon
        Frequent Visitor
        8 years ago

        Hi,

         

        I have tried to do a measure and got the following error when trying to use the Card visual