Visokio website     Downloads     Video tutorials     KnowledgeBase  
Why don't I get a nice line graph when I choose Connect Markers? - Visokio Forums
Why don't I get a nice line graph when I choose Connect Markers?
  • Guy_Cuthbert        Guy_Cuthbert December 4, 2008 9:07AM
    The Omniscope Graph View is a very flexible means of plotting point/bubble graphs, and with a little effort can produce very effective line graphs... but lots of people struggle with the Connect Markers option.

    Before you Connect Markers you need to think about the nature of your graph and how it relates to your underlying data; specifically, is your underlying data exactly what you want to graph or not? For example, if your base data represents sales of items by week in a range of stores, then when you plot a graph of Sales Value (Y) against Week (X) you need to remember that you will have many points of the graph for each week - one for every combination of store and item (subject to active filters). If you want to see a single line on the graph when you Connect Markers you first need to aggregate your data...

    In this case, with sales of items by week by store, you would need to aggregate by Week to get a single Sales Value for each week, which you can then plot, Connect Markers and view a single line.

    If you wanted a line per Store (reasonable if not too many stores are selected) then you would need to aggregate by Week and Store, and then select to show a line for each Store in the Connect Markers options.

    If you leave the base data alone and do not aggregate (and aggregation is not possible in Omniscope releases before 2.4) then Omniscope will do what you ask, and Connect Markers... but with a marker for every store/item comination the lines that Omniscope draws between them result in a confused mess on screen.

    So think through your aggregations needs first, and then Connect Markers will give you the line(s) that you require... and a little exploration of the many Connect Markers options will let you smooth, trend and colour the resultant lines.

    Happy Line Graphing!
    Atheon Analytics Ltd
    w: www.atheonanalytics.com
    e: guy.cuthbert@atheon.co.uk
    t: +44 8444 145501
    m: +44 7973 550528
    s: guycuthbert
  • 0 Comments
  •        mohamed February 17, 2009 3:23PM
    Thank you
  • Guest February 17, 2009 3:46PM
    Thank you
  •     mustafa February 18, 2009 2:38PM
    Thank you
  •     mustafa February 18, 2009 2:40PM
    great

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership