Visokio website     Downloads     Video tutorials     KnowledgeBase  
Bar/Line View: Displaying null or zero value bars on X-axis - Visokio Forums
Bar/Line View: Displaying null or zero value bars on X-axis
  •     misakch July 2, 2012 11:18AM
    Hi - Is there a possibility, how to set a fixed values on the x-axis? My situation is as follows. I have a values of investment into different mediatypes per month and i want to create a bar view showing overall investment in each month (i.e. 12 bars). The problem is, that not all media types has values for each month (there was no investment in specific media type in given month). When I set a filter showing only mediatype with missing value in one month, this month is missing also on x-axis (in bar plot is then only 11 bars). Is there a way how to avoid this and have on the x-axis still numbers from 1 to 12 (as a months). The one with missing value will be empty or with null value respectively.
    Thanks a lot, Michal
    Michal Charvat | Mindshare | Business Planning | www.mindshare.cz | www.mindshareworld.com
  • 17 Comments
  •     paola July 2, 2012 11:35AM
    Hi Michael,
    In your Bar view, click on the Split menu. Next to your split choice click on the Fit to Screen words. You will get the choice to fix the size of the interval, or number of intervals, in this case 12.
  •     tjbate July 2, 2012 11:39AM
    Also, make sure you have specified the option:

    Bar/Line View: View toolbar > Tools > Empty data buckets > Always/Show empty buckets
  •     misakch July 3, 2012 3:08AM
    Thanks for your reactions and valuable advices. Unfortunately my problem still remains. The problem is, that the choice of number of intervals only allows to limit the maximum number to 12, not to set the fixed number of intervals. Thus, if the value of investment for (for example) January and February is missing because in these months were no investment, my bar plot starts in March with first non-null value instead of in January (with value 0) and February (with value 0).

    In graph view is a possibility to simple set the "Extend axis to custom range (x axis)" from 1 to 12 and problem is solved. But I didn't found analogous option in bar view.

    Thanks again for your answers.
    Michal Charvat | Mindshare | Business Planning | www.mindshare.cz | www.mindshareworld.com
  •     paola July 3, 2012 8:43AM
    Hi Michael,
    We tried to recreate your problem by creating a sample file with zero value for Jan and Feb 2012, and a null/missing value for Dec 2011. The Bar/Line View can recognise/display both. Please have a look at the sample file below and compare the settings, field formats etc. If the problem persists, please send me your file (or simplified version), so we can have a look. Thanks
  •     misakch July 10, 2012 2:49AM
    Hi Paola,
    Thanks for attached file and sorry for the delay of my response. In your particular case everything works fine but only because of the null value in Jan and Feb. My problem is, that for certain filtering options i do not have any value for these months. As you suggested, one example is worth thousand words. Everything is described in footer of appropriate views. Dont bother to contact me anytime, I really appreciate your help.
    Thanks,
    Michal
    Attachments
    TimeSeries.iok 13K
    Michal Charvat | Mindshare | Business Planning | www.mindshare.cz | www.mindshareworld.com
  •     paola July 10, 2012 6:25AM
    To address the question regarding the attached file - if you wish to display months with missing values you need to add those months to your data set. When months 10, 11, 12 were added - they appeared on the histogram, with no value.
  •     paola July 10, 2012 7:00AM
    Another answer related to the attached file - useful way to show several years with months 1 to 12 on x axis is to choose option Layer by [Year]. You can then choose from Preset menu to either have layered lines or bars, interleaved mesures, for different years for easier comparison.
  •     misakch July 10, 2012 7:11AM
    I see the logic behing proposed solution of problem with displaying months with missing values. Nevertheless, practically is not possible because I would have to add months for every possible combination of filters. Real data set contains not only information about mediatype but also about category, advertiser, brand etc. Therefore I would have to add missing months for each mediatype by category, advertiser, brand and every other combination respectively. I do not want to waste your time with meaningless questions, so my last one is brief. Is there any way how to arrange fixed values on x axis in bar/line view as in graph view ("Extend axis to custom range")?
    Thanks again for your time,
    Michal
    Michal Charvat | Mindshare | Business Planning | www.mindshare.cz | www.mindshareworld.com
  •     paola July 10, 2012 8:18AM
    In Bar/Line View you have option under Axis menu>Custom Axis range to set range on Y axis.
    On X axis you can specify number of intervals OR size of the interval. If you click on Split, words Fit to Screen, you will get these options.
  •     misakch July 10, 2012 9:25AM
    Ok, thanks.
    Michal Charvat | Mindshare | Business Planning | www.mindshare.cz | www.mindshareworld.com
  •     filippobe September 19, 2012 8:42AM
    Hi Paola,

    I can't find the option to set a range on Y axis when I use Bar/Line view.
    Which one is the axis menu? Could you please post a screenshot?

    Thanks,
    filippo
  •     filippobe September 19, 2012 8:48AM
    Here is a screenshot of the issue.
    The difference between my lines is really small (few basis points), therefore I need to change the scale (range) of my Y axis from 0-100 to something like 100-102.
    Attachments
    image1.jpg 799K
  •     paola September 19, 2012 10:00AM
    Y axis custom range functionality will be available soon, with release of Omniscope 2.8.

    In the meantime, you should use the Graph View, that will automatically adjust the Y range in a situation like this. You might have to use aggregation function to aggregate values for different categories. There is also an option to connect individual dots, where necessary.
  •     filippobe September 19, 2012 11:02AM
    Thanks. Is there an alpha version of 2.8 I can download? I know that the adjust Y range function is available in graph view, but I would need to use Bar/Lines view also for other reasons.
  •     paola September 19, 2012 11:44AM
    Hi Filippo, I emailed you directly.
  •     rng May 22, 2015 4:43AM
    I'm facing a similar issue on the plotting time dimension on X-axis of a Bar Graph.
    The scale/interval is restricted to measure values unlike the Graph view where the time window can be configured by defining scope of view (using 'zoom')

    Also, amending 'Interval' length under the split-menu doesn't seem to have an effect if the time-dimension measures are limited.

    The filtering would override 'adding dummy values' tactical fix you've suggested above.
  •     paola May 22, 2015 6:09AM
    Could you please send us a data sample and explanation what exactly you wish to see on your Bar/line view - what kind of splits?

Welcome!

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

Sign In Apply for Membership