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

Notification

Icon
Error

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

Rank: Newbie

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

Thanks: 1 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.

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

Rank: Administration

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

Thanks: 7 times
Was thanked: 84 time(s) in 81 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.