I have a vertical bar chart based on a data series created by and sql statement. This is the data:
08/03/2018|001|CHINOOK|4
08/05/2018|001|CHINOOK|9
08/07/2018|001|CHINOOK|14
08/08/2018|001|CHINOOK|24
08/15/2018|001|CHINOOK|31
08/16/2018|001|CHINOOK|42
08/24/2018|001|CHINOOK|51
08/25/2018|001|CHINOOK|231
08/02/2018|004|COHO|2
08/04/2018|004|COHO|3
08/05/2018|004|COHO|5
08/07/2018|004|COHO|6
08/08/2018|004|COHO|7
08/24/2018|004|COHO|14

Although the first column looks like a date, it is actually a text field which changes format depending on time strata selected by user: day, week, month, year.
The problem is that the time strata is not what is showing on the x-axis labels, even though that is what is defined as the category in the chart definition. It is showing instead, the values of the bar.
I was going to show a screen print of the chart definition and the results, but can't get this post to accept a screen print.