I have a table with a column that I have configured as a choice, the choice values are numbers.
Now I want to make a chart based on the sum of the values in this column.
I can't work out how to do this as only get the option to "count". I'm assuming as Sum is greyed out they are stored as text or something?
I also tried to change this to a lookup column to another table with a number value, but still Sum is greyed out.
I've watched a few youtube tried searching for documentation, but can't find anything on how to do anything slightly more complex with charts other than count.
How can I get Sum working?
Anyone point me to some good documentation on using ModelDriven app Charts?
Choice(s) is its own (complex) datatype it is not a Number datatype and so it will not Sum in the Chart. Your options would be to either: