Clustered Columns Chart

Example

Illustration

Summary of settings

  • Type of chart: Columns
  • Mapping of x attribute: City
  • Mapping of y attribute: Profit
  • Filters: Two historical dates selected
  • Common attributes → Split mapped to AsOfDate dimension
  • Specific attributes → Columns → Column Type set to Clustered

Step-by-step instruction

  1. Add new Chart Widget

  2. Select Columns

  3. If there are multiple cubes connected to your application, you must select the cube you want for the chart.

  4. To map the x attribute, select the groups you would like to see on the horizontal axis, City

  5. To map the y attribute, select the value (measure) corresponding to the vertical axis, Profit

    The chart displays the mapped axes:

    Illustration

  6. To split columns by AsOfDate, in order to compare day-to-day dynamics, click Options in the legend area of the chart:

    Illustration

    In the Options popup, find attribute Split and map it to the desired dimension.

    Illustration

  7. Apply a filter to view only the two dates needed Filters)

  8. In the Options popup, scroll down to find the Specific attributes section. Click the Columns icon and look for a setting called Column type. By default it is set to Clustered. Change it to Stacked and compare.

    Illustration

The example is complete:

Illustration

Back to Legacy Chart Gallery

Appendix

The appendix contains code snippets for advanced users.

MDX:

SELECT
  NON EMPTY Crossjoin(
    [Geography].[City].[City].Members,
    [Time].[HistoricalDates].[AsOfDate].Members
  ) ON ROWS,
  [Measures].[Profit] ON COLUMNS
  FROM (
    SELECT
    {
      [Time].[HistoricalDates].[AsOfDate].[2018-05-07],
      [Time].[HistoricalDates].[AsOfDate].[2018-05-08]
    } ON COLUMNS
    FROM [EquityDerivativesCube]
  )

JSON:

{
  "configurations": [
    {
      "handlers": {
        /* ... */
      },
      "type": "combo-histogram",
      "mapping": {
        "x": {
          "from": ["[Geography].[City].[City]"]
        },
        "y": {
          "from": "[Measures].[Profit]"
        },
        "color": {
          "from": ["[Time].[HistoricalDates].[AsOfDate]"]
        }
      },
      "legend": {
        "display": "hidden"
      }
    }
  ]
}