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?