Dates are out of order on chart


Author
Message
Bob Smith
Bob Smith
Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)Forum Guru (69 reputation)
Group: Forum Members
Posts: 69, Visits: 1
I have a stepped line chart that plots points according to their value on the y axis and their date on the x axis.

For some reason the date 1/10/2013 is being drawn to the chart *before* 1/1/2013...

Also, I would *like* to set the X axis as a date range and not just the dates from the data points. I don't know how to modify the X axis to represent a range of dates.

I've attached a screenshot of the issue.
Reply
Nevron Support
Nevron Support
Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)Supreme Being (4.5K reputation)
Group: Administrators
Posts: 3.1K, Visits: 4.2K

Hi Bob,

This may be an issue with the values and the corresponding date time – actually the grouping.

You can try to add Sorting in the Pivot >> Data Groupings >>  Categories >> Sorting. Something like:
Expression: =Fields!Time_Stamp.Value
Direction: Ascending

Let us know if this helps.

PS - there was no screenshot with your post, please try to attach it again.



Best Regards,
Nevron Support Team


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search