Rank: Newbie
Groups: Registered
Joined: 6/17/2019(UTC) Posts: 1  Location: brasilia Thanks: 3 times
Was thanked: 2 time(s) in 2 post(s)
|
I have Classic Revenue X Expenses Line CHART. In the Model, i dropped on columns, the MONTH/YEAR period. But the axis of the lines are always in the worng order. I have already tried: [1]Sort Order for the MONTH/YEAR Column [2]Sorting and Grouping in many ways my SQL Query [3]Tried JS, Plotly and NVD3 Is there a way to control this??  
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Di you check sample '05-Charts Gallery - Advanced', there are a few charts having a Date Time axis.
If your Axis is a Date Time type, there is a property 'Use values for axis' to be set to true to force the ordering of the Axis.
According to your screen shot, the value is not displayed, this means that the type of the column ins incorrect, please check this first.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 9/13/2018(UTC) Posts: 41  Location: Ottignies Was thanked: 2 time(s) in 2 post(s)
|
Hi, I don't know if your problem is solved in the meantime, but there is one sort options that you have not mentionned in your list. That is the one on the measure (Data element), in the chart properties group, there is the Sort Type option.
Most of the time I set it to 'No Sort' to make sure the sort order of the graph is not the Column elements.
BR
|
 1 user thanked CPBOURG for this useful post.
|
|
|
|
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.
