Visokio website     Downloads     Video tutorials     KnowledgeBase  
Idea: Bar/Line View - background guidelines Mean+/- 'n' STDs? - Visokio Forums
Idea: Bar/Line View - background guidelines Mean+/- 'n' STDs?
  • VoteVote Up5Vote Down     rajeshbalu29 July 2, 2014 3:25PM
    Hi Team,
    Please find the attached Excel chart format in which the plot area has been formatted with calculated gradient effects.
    Can we have this available in Omniscope for one of our important report requirement?
  • 13 Comments
  •     tjbate July 3, 2014 5:30AM
    Rajesh - We have re-classified this as an Idea. We will analyse the requirments, and welcome other comments/suggestions on this thread.
  •     paola July 3, 2014 6:18AM
    In Omniscope you can specify colour grading for numerical fields, setting the 'ramps' in:
    Data>Manage fields>Field options>Value colouring
    In the example below I used 'pick' option on the colour palette to 'lift the colours' from your chart, picking the exact shade of red, yellow and green (place the marker over the colour and hit Enter or Space).
    We currently have 3 colour grading points, but are considering adding more.
    As for the Area chart itself, we do not have this option, and it would be interesting to see whether it has informative side, in addition to its decorative purpose :)
    imageimage
  •     rajeshbalu29 July 7, 2014 4:14PM
    Thanks for your feedback Paola and Thomas.
    @ Paola, Can this be integrated with the configuring color gradient and use under the attached COLOR GRADING IN BAR CHART snapshot as attached?

    Note: I have multiple measure which has different value but there should be common coloring scheme for all calculation on a bar chart.

    Thanks & regards
    Rajesh B
  •        daniel July 8, 2014 4:09AM
    The plot area can be affected using the stats on the graph view where you can define regions by colour, is it possible to actually put the gradient colouring into that interface? Perhaps expand those options for the Bar/line too?

    image

    image
  •     paola July 8, 2014 6:33AM
    Zones in the Graph view probably come closest to your request, as Daniel suggested, and you can have either custom zones on X / Y axes or both, using the mean, max, min, standard deviations and other functions to define the range, or decide on custom values. Each zone's colour can be customised, labelling and borders too. Please see image below.
    image
  •     bgrovens July 11, 2014 4:20PM
    Hi Paola, This is really critical to get added to the bar/line functionality for our user base. I think this thread may confuse people on what's really needed. How can we send out to get a better voting poll?
  •     tjbate July 12, 2014 1:13PM
    Brian - The purpose of these Ideas threads on the Forum is to refine and optimise feature requests, as well as gauge interest. Why not post the requirement as you see it, ideally with a sample IOK data set illustrating the type of story you are trying to convey?

    So far, this discussion appears to include three discrete proposals

    1.) plot area gradient backgrounds like Excel, but with boundaries at +/- sigmas
    (why is this better than breaking at zone lines?...see next option)
    2.) plot area coloured zones with boundaries at +/- sigmas
    (existing feature, see example above) and,
    3.) adding a continuous value colouring option with user-definable breakpoints not only at mean (existing) but also at +/- 1 and 2 sigma.

    For any numerical field, it is possible to customise the value-colouring behaviour field-by-field from:

    Data > Manage fields > {Field} > Options > Value-colouring

    Currently there are many options for controlling start value/colour, end value/colour, choice of 2 or 3 inflection points, middle colours and even adjustments for skewed mean distributions. Is the idea to add an option to define a 6 inflection point option with start, -2, -1, mean, +1, +2 sigma and end as breakpoints for changing graded colouring?

    But this is not really gradient colouring, since it seems like you want to assign the same fixed colours to ranges and points beyond internal limit values, i.e. values above & below +/- 2 sigma might be same colour?

    You can do something like the below by setting the start and end values to be +/-2 sigma (not the extreme values of the field) with the same start & end colour and a different middle colour...
  •     rajeshbalu29 July 15, 2014 1:01PM
    Hi Thomas,

    Thanks for the updates, but zone colouring works only for Graph View chart and not for Bar/Line View charts.

    We have this requirement based on Bar/Lines charts.
  •     paola July 15, 2014 2:24PM
    Not sure if this would help as a workaround, but you could add formula fields to create Mean and +/-STD values, then add them as measures to the Bar/line view, creating the zones, similar to Graph view. It will not colour the plot area, but will work as border for other bars/lines, and you will be able to chose the line thickness and colour.

    Add formula fields to the dataset, with formulas like this:
    SUBSET_MEAN([Value])
    +
    SUBSET_STDDEV([Value])

    (chose mean under measure menu in the Bar/line view)
    Demo file attached.image
  • tagarw August 18, 2014 4:43AM
    Hi Paola,
    Please have a look at current file attached. In this file if I add column formula in measures with a value 4( As I need a straight line at 4). The line is getting combined with -1std line. Cannot we make this independent??
    Attachments
    Current file.iok 16K
  •     tjbate August 21, 2014 12:15PM
    Jagran - You need to use the 'Bars on Lines' layout preset, then use an added formula measure with the simple constant value of 4:

    image
  • tagarw September 1, 2014 5:04AM
    For my actual report the graph is very complecated and things are completely messed if I use "Bars On Line" Layout.
  •     tjbate September 1, 2014 5:42AM
    Jagran - Remember that you can have many views on a tab, and unlimited tabs and (unrelated) datasets in an IOK file. The purpose of interactive visual reporting is to guide the consumers of the report, dashboard or decision support tool through a 'story' that gives them confidence in their decision-making.

    It is tempting to pack a lot into one interactive view on one tab trying to create a single 'tool' view that can answer all questions. This is not, however, easy for consumers to digest.

    In general it is better to use defined Subsets and Named Queries, Tab and View footers, Tab links and Content View and Helpfile text to 'spread out' the story across multiple tabs and views, some tabs sharing the same filter and Variable settings, so that the consumer is 'guided' through the story.

Welcome!

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

Sign In Apply for Membership