Bar/Line View: Ordered Dates along Bottom Axi?

schergr · January 23, 2012 5:44PM

I have a Bar/Line View which along the bottom (split) axis contains a series of dates (data imported from Excel in the date/time format -- 3/14/2012) the dates are not sorting in chronological order and I'm trying to figure out how to ensure that the dates are displayed chronologically.

Any thoughts?

tjbate · January 24, 2012 4:48AM

Greg - Please see this discussion:

http://forums.visokio.com/discussion/comment/4273/#Comment_4273

Line81 · July 19, 2012 5:31AM

I have the same question about sorting the X-axis to date. Unfortunately, I couldn't find an answer in the link above as it only treats day of the week. Anyone else an idea? Many thanks!

paola · July 19, 2012 6:03AM

Hi, firstly you need to make sure that Omniscope field format is Date/Time. The fact that you imported date field from Excel does not guarantee you that format will be preserved.
If your records are showing date, and you wish to display records on a weekly/monthly basis, you will use Split>Date and then click on Fit to Screen option to format your interval to be 1,2, 3 weeks/months...

Welcome!

Categories

Ideas Parade

Tagged