Forum Discussion

pmr2000's avatar
pmr2000
Frequent Visitor
7 years ago
Solved

Cannot change from count to a sum

I have a line and stacked column chart.  The stacked column values appear fine, when I add a field to the line values I can only get "count" - no option to change to "sum".    The pulldown does not...
Tips and Tricks
  • parry2k's avatar
    parry2k
    7 years ago

    pmr2000 awesome, it worked out. Cheers!!!

pmr2000's avatar
pmr2000
Frequent Visitor
7 years ago

Good suggestion if I try that YTD Target in another visualization same issue only get the count choice.  If I put it in a table I see actual values though.

 

Definitely formatted as number, I will keep trying!

pmr2000's avatar
pmr2000
Frequent Visitor
7 years ago

If I try the line value in another using YTD Target I get sum - however it is adding the entire row of months together and giving me flat line of January to December as the sum of the column, not individual values for each month?

 

 

  • pmr2000's avatar
    pmr2000
    Frequent Visitor
    7 years ago

    I don't see the delta summation symbol next to the column I want as line graph  - how can I change that?

     

     

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      pmr2000 that tells me that it is not a number field, can you share the screen shot with selected field and data type of the field.

      • pmr2000's avatar
        pmr2000
        Frequent Visitor
        7 years ago

        I was able to create a new table in excel, refresh, seems to work now.  

         

        Can't see any issue with the old data not being formatted correctly but like you said the summation delta symbol indicates an issue.

         

        Thanks so much!