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.