Forum Discussion

Afilingeri's avatar
Afilingeri
New Member
9 years ago
Solved

Data not populated properly

Hi BI community. As a new user to the product, I am continuously getting stuck on basic issues that I am certain can be easily solved with your help. My current frustration is trying to figure out why my data on the below graph is currently showing up as "1" when it is clear from the data above that the values are different. What am I doing wrong? Thank you in advance for any help!

 

  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Afilingeri

     

    Plases Follow this steps:

     

    1.Change the Data type of this columns to Number

     

    2.Select SUM

6 Replies

  • dilumd's avatar
    dilumd
    Icon for Impactful Individual rankImpactful Individual
    9 years ago

    I think your problem is this,

     

    Change "count" to "sum" as shown below.

     

    • Afilingeri's avatar
      Afilingeri
      New Member
      9 years ago

      Hi! Thank you so much for the quick response. When I tried bringing up that window you have in the preview, I only get minimal options (seen below). If I hover over "show value as" I only get two options reading "percent of grand total" and "no calculation". I have clicked on the side arrow dropdown as well as right-clicked with the same result. How do I get that extended window with additional options that you've produced here? Thank you again for the help.

       

       

       

      • Vvelarde's avatar
        Vvelarde
        Icon for Community Champion rankCommunity Champion
        9 years ago

        Afilingeri

         

        The reason to your problem is your fields are not numbers.

         

        You should delete the first row and let only numbers in the field.

         

        You can delete in Edit Query. Remove Rows.

         

        Regards

         

        Victor

        Lima  Peru