Forum Discussion
Do not summarise chart value
New user here. I am trying to display line chart from numeric data.
The chart is formatted as follows:
x-axis: date information with column formatted as "Date"
y-axis: numeric data with column formatted as "Decimal Number"
The date info has been set to "Axis" in the line chart configurator and the numeric data as a single data set to "Values" however data in "Values" is only available in summarised form (i.e. "Sum", "Average" etc, etc). I want to be able to view mutiple numeric data values with the same date value on the chart and not aggregated data for a specific date.
In the data model screen I have set the data to "do not summarise" but this has not helped.
Any help much appreciated, Thanks.
I'm not aware of a way to do that. If you want them on separate rows/columns, you will have to make the axis values unique.
4 Replies
I'm not aware of a way to do that. If you want them on separate rows/columns, you will have to make the axis values unique.
Thanks, much appreciated.
I'll set up a serial number field that concatenates in the the date "X-YY-MM-DD" to create a unique value for the x-axis and still give some readable chronology to the data.
Created a unique ID field called "Date Time" (record creation date and record creation time, concatenated together), dropped this into "Creation Date" to create a hierarchy which includes my new field "Date Time". This allows me to create a quasi-scatter plot in the line graph where data points are stacked by "Creation Date" if I use the "Creation Date" hierarchy in the "Axis" chooser in the chart tool which is actually a pretty useful way to look at the data.
