Forum Discussion
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 have all the options sum, avg. etc. only see count (distinct) and count choices.
I have the source data formatted as a number, custom -it's currency format.
I do have 2 rows that are blank, I tried putting 0's in did not fix.
Any suggestions? Thanks in advance.
9 Replies
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
Super User
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?
