asked on August 10, 2018
Hi!
We get the data in date as a column format (see attachment: date_as_column.png). When changing from the Pivot display to line/bar/line+bar the visualization isn't setting the date as an X-axis. Instead, there will be awkward visualization where each month its own color (see attachment: no_date_in_x_axis.png).
The user of the system can fix this by flipping the Cols and Rows definitions (see attachment: flipped_definitions.png), but this is not very intuitive. The visualization is then correct (see_attachment: one_set_per_month).
Is there any way to get the graph to take date values from the columns, so that it would become X-axis in the graph?
Thanks!
⋅ August 10, 2018
Hello, Tatu,
Thank you for writing to us!
We suggest using reversedAxes option which flips the Cols and Rows when displaying the chart. For more details please refer to our documentation: Options Object.
Does it work for you?
Regards,
Tanya
