Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.

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



Go to last post Go to first unread
#1 Posted : Tuesday, July 2, 2019 10:07:55 PM(UTC)

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??


#2 Posted : Wednesday, July 3, 2019 7:03:41 AM(UTC)

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.

#3 Posted : Wednesday, October 9, 2019 8:00:22 AM(UTC)

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.

thanks 1 user thanked CPBOURG for this useful post.
epf on 10/9/2019(UTC)
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.