Profile Picture

Dates are out of order on chart

Posted By Bob Smith 11 Years Ago
Author
Message
Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

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
Last Active: 11 Years Ago
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.

Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

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



Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

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
Last Active: 11 Years Ago
Posts: 69, Visits: 1
Appears that sorting has no impact whatsoever. Apparently datetime values are evaluated differently than I thought...

I'm getting the following error message for .jpg, .JPEG and PNG files:

One of the files you have attempted to attach to this post is not a permitted MIME type.

What is the permitted file type for screenshots?

Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

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
Last Active: 11 Years Ago
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!

Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

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
Last Active: 11 Years Ago
Posts: 69, Visits: 1
I think GIF files can get through. Attachments are a little silly at this point, but it may help someone else who uses this topic as a reference.

The picture quality is pretty bad, but I think it demonstrates the issue just fine.

Attachments
DateValueNoSort.GIF (356 views, 8.00 KB)
Nevron Support
Posted 11 Years Ago
View Quick Profile
Supreme Being

Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)Supreme Being (4,329 reputation)

Group: Forum Members
Last Active: Last Year
Posts: 3,039, Visits: 3,746

Most likely this is because the data in "Date" field is not recognized as DateTime values. Probably you have an Excel spreadsheet and use the Excel Services connection. By using the DATETIME function you should be able to convert to DateTime value. The date time is parsed according to the specified culture. If culture is not specified the value is parsed with the current thread culture. Check out the DateTime.TryParse documentation in MSDN for a complete discussion.

Regarding setting the X axis as range of dates, can you please elaborate.
The following KB topic describes how you can filter the chart based on a begin and end date: http://support.nevron.com/KB/a206/filter-the-chart-web-part-based-on-begin-and-end-date.aspx

 



Best Regards,
Nevron Support Team



Bob Smith
Posted 11 Years Ago
View Quick Profile
Forum Guru

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
Last Active: 11 Years Ago
Posts: 69, Visits: 1
To elaborate on setting the X axis as a range of dates see the last post in the following thread:

http://forum.nevron.com/shwmessage.aspx?ForumID=13&MessageID=7362

This resolved the issue that I was having



Similar Topics


Reading This Topic