Forum Discussion
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...
parry2k
Super User
Super Userpmr2000 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?
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!
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?