Versions Compared

Old Version 15

changes.mady.by.user Denise McGettigan

Saved on

compared with

New Version 16

changes.mady.by.user Denise McGettigan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
  • The x axis displays the total. This always starts at zero.
    • The y axis depends on the mode. In period mode and moving mode, the y axis will display
    A bar chart displays a number of
    Info

    Availability:

    • Summary view-All modes except for Transaction mode.

    • Focused view (when you select and focus on items in a dimension) - All modes except for Search, Transaction and Market.

    A bar chart displays several variables together, similar to a column chart. Bars charts Bar charts are good for displaying simple comparisons, e.g., to display the for example, the top 10 product sales , or monthly output.  

    Once you select a dimension, you will see a bar for each focused item in the dimension. In summary view there will be a bar each for current and previous period or stream.

    Working example 

    In this example, we want to create a bar chart to compare office expenses for the current financial YTD vs. the previous year.

    Info
    iconfalse
    titleRelated articles

    Step 1: In this example, we'll use our 'Finance' database, and prepare our grid as shown below, with these selections: Variance mode, 'sub account' dimension, financial YTD, and three items selected: Stationery, office consumables and postage.

    Image Removed

    Step 2: Choose Chart and select bar Image Removed.

    . You can hover over data points to display the underlying values.

    The following table describes what the bar chart looks like in each view.

    Summary view

    Focused view

    Bars

    There is a bar for each time unit (month/day/year) in the current period.

    There is a bar for each of the focused items.

    X-axis

    The X-axis displays the total, which starts at zero.

    The X-axis displays the total, which starts at zero.

    Y-axis

    The y-axis displays the time units of your current period. 

    The contents of the y-axis depends on the mode. In Period and Moving mode, the y-axis displays the time units of your current period

    (e.g. months/days/years). In variance mode, stream mode and total mode

    . Whereas, in Variance, Stream and Total mode, the y-axis

    will display

    displays each focused item

    in the current dimension. 
    Image Removed

    The office expenses this YTD are shown in blue vs. last YTD in red. The chart can now be saved as a favorite or added to a dashboard.

     

    .

    Example

    		Image AddedImage Added

    Example - Create a bar chart

    In the Sales database, you want to create a bar chart to compare the performance of the top five Sales Reps for the current financial year to date with the previous year.

    1. Prepare the data in the grid:

      1. Select the Sales Rep dimension, then select and focus on the top five Sales Reps.

      2. Select Mode > Variance.

      3. Select Period > Financial TYD (year to date).

    2. Click the Chart (blue star) button. The bar chart type displays by default. You can now compare the sales for each of the five Sales Reps this year to date (blue bars) with that of last year (red bars). 

      Image Added

    3. (Optional) Save the chart as a favorite or add it to a dashboard.

    On this page

    Table of Contents
    minLevel1
    maxLevel2

    Related pages