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!!!

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

pmr2000 are you using the same column on for stack bar ?

pmr2000's avatar
pmr2000
Frequent Visitor
7 years ago

No, I am not using the column that I want to use for line value in the column values.

 

Basically have 5 columns- 1 column for date, columns for forecast, actual, ytd, ytd target.

 

Date column is the shared axis

Column values are forecast, actual, ytd.

Trying to use ytd target as the line value, only get it to display as count not sum.

 

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    pmr2000 not sure why you are not getting aggregation option for your line, can you try to use "YTD Target" on some other visual and see if you have aggregation options for that column. Only reason I can think of that data type for the column is not number? Can you double check that?

    • 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?