Rank: Advanced Member
Groups: Registered
Joined: 5/18/2018(UTC)
Posts: 40
Thanks: 2 times
|
I have a SQL Server database table that has an integer year and month and I'm combining them via cast(table.year.Year as nvarchar(4)) + '-' + right('0' + cast(table.Month as nvarchar(2)),2) and overriding the data type as 'text'. I have the value set as an Axis with 'Automatic Ascendant' (and I've tried 1 Ascendant as well), and the X axis on the chart is coming up random. I have 2 charts pulling from the same table and they don't even match each other.
It is coming up 2017-12, 2017-11, 2018-03, 2018-02, 2018-01,2017-10.
Is there a trick to getting them to sort in the chart correctly? I've tried Line and Stacked Area charts.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
The chart sorting i s controlled by the 2 properties:
Sort Type (By Point or Axis Label) and Sort Order...
Did you try all these options ?
Did you try different chart type: ChartJS, Plotly and NVD3 ?
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
