Time series - x-axis does not display the entire period

TTWB · October 30, 2012 11:02AM

Hi
I'm pretty new to Omniscope, so sorry for my newbie question.

I'm working with time series, one variable (for the simplicity...) on a weekly level. Question is: My x-axis does not show the timeperiod from my datafile (xls). The Omniscope graph starts the data in week 1, instead of week 30 as in my excel file. See attached screendump. How can I fix this.
Thanks for your time

paola · October 30, 2012 12:58PM

Please check how is your [Week] field formatted? Is it Date/Time (with year specified) or is it imported as Integer/Number?
Omniscope needs date information, as point in time, in order to create time series, and 'understand' that week 30, 2011 comes before week 1 in 2012.
If that information is missing, week values will be split in ascending order along the axis 1-52 ... Please send us or post here a file, so we can give you a specific answer.

TTWB · October 30, 2012 4:14PM

Hi
Thanks for your input. The underlying data is formated with years, and changed in Omniscope to Weeks. See attached.
Hope you can help.
Thanks for your time

paola · November 1, 2012 3:22PM

Your data is in the Graph view. You should chose Date field to split by on X axis, then in Graph view aggregate the Date field, and under Histogram choose weekly intervals.
You can also tick 'smart labelling', to transform weeks into format W5/2011.

	Test.iok	10K
	Stofa Input Data.xls	120K

Welcome!

Categories

Ideas Parade