Mike - Omniscope usually arranges time series data 'vertically' i.e. repeated observations over time are rows, not columns. The Omniscope De-Pivot operation can change the orientation of your data automatically and store it in very compact IOK format. If you store your 'vertically' oriented daily or weekly 'timeslice' IOK files in a folder, you can use the Desktop Edition Batch Append data connector to automatically append/combine all the timeslice files and show the trends to date in another IOK file.

If you have a Server Edition, you can automate the entire process of accessing the source, timeslicing and storing a growing archive of time series data in IOK files, often aggregated to 52 weekly rows or 356 daily rows per year with aggregation functions and formulae transforming all the column values. The Server Edition can also automate distribution of the IOK trend reports with the product range and number of timeslices/length of the time series personalised to each recipient's own IOK file.

Thanks for the reply!

I have a fully licenced/paid for edition, and as I am new to the software, would you be able to point me in the direction of how to do this?

So 1) Need to De-Pivot data and change orientation -so i want it horizontally? e.g.

March 13th March 14th March 15th etc
Product

Product A 85% of distribution ranged 90% 95%

Product B 98% 97% 98%


2) Need to get the Desktop Edition Batch Append data connector

3) Sit back and enjoy the data roll in!

Would it be easier to discuss this over the phone? - I would like that :-)

Thanks very much

Mike

Hi Mike, there are a number of points to address here, around how Omniscope behaves differently to excel. From discussions, you will need to get to grips with the basics of storing 'time-series' data, and merging (joining or concatenating) new sets of data.

There are a number of options for how to do this, and I will talk you through the best one once I have seen the data that you are collating.

If you would like to see a quick demo video around how data can be merged in Omniscope, please refer to this Atheon Analytics training video: http://www.youtube.com/user/atheonanalytics?blend=18&ob=5#p/a/u/1/EIU_w9IZcos

There are a number of other beginner videos in the series, and all of the basic and advanced techniques are taught on the Atheon 'Introduction to Omniscope' 1 day training course.

For more info please contact me on ian.hall@atheon.co.uk