Welcome Guest! To enable all features please Login or Register.



Go to last post Go to first unread
#1 Posted : Friday, May 18, 2018 2:30:49 PM(UTC)

Rank: Member

Groups: Registered
Joined: 5/18/2018(UTC)
Posts: 15

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.

#2 Posted : Tuesday, May 22, 2018 7:00:32 AM(UTC)

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 653

Thanks: 9 times
Was thanked: 111 time(s) in 108 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 ?
Users browsing this topic
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.