If we choose a column for the chart of character data type, it is showing only the columns with numeric data type in the value field. Instead, it should be generic like "Total", "Count", "Sum" etc.
Issue Description: In iview/reports plot a chart where we can find the total/sum against the selected category/column.
Example: A chart showing the total number of male/female.
Solution: In definition, add a hidden column with numeric data type and expression as "1".
The expression gives the sum/total of the selected column in the chart.
i.e., x-axis column: gender column and y-axis column: hidden column created as per example.