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
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
Ok, I solved it.

The solution was this:

=DATETIME(Fields!Date)
Sort: Ascending

I guess it wasn't looking at the "DateTime" values as "DateTime" values until I put them in that expression. Looks like it works!
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