Scatter Plot

Example

Illustration

Summary of settings

  • Type of chart: Scatter plot
  • X Values: HPL
  • Y Values: RTPL
  • Split by: AsOfDate

Step-by-step instruction

  1. Add new Chart Widget

  2. If there are multiple cubes connected to your application, you must select the cube containing the data that you will use in this chart.

  3. Switch type to Scatter plot

  4. Add HPL to X Values. Note that you can use any measure or formula instead.

  5. Add RTPL to Y Values.

  6. The initial chart displays one point, the value for the measure selected on X Values plotted against the value for the measure selected on the Y Values.

    Illustration

  7. Select Members you would like to display on the chart by adding a hierarchy in the Split by section of the "Fields" Content Editor tab. In this case members of the dimension AsOfDate.

    Illustration

    To restrict data in the view, use Filters

  8. Adjust Marker Size as described here

  9. Add Axes Titles as described here

  10. Mouse-over displays a point's attributes and values.

    Illustration

Back to Chart Gallery

Appendix

The appendix contains code snippets for advanced users.

MDX:

SELECT
  NON EMPTY {
    [Measures].[Hypothetical PL],
    [Measures].[Theoretical PL]
  } ON COLUMNS,
  NON EMPTY [Dates].[Date].[AsOfDate].Members ON ROWS
  FROM [PLSummaryCube]

JSON:

{
  "type": "container",
  "writable": false,
  "name": "Chart",
  "value": {
    "style": {},
    "showTitleBar": false,
    "containerKey": "chart",
    "body": {
      "configuration": {
        "plotly": {
          "data": {
            "commonTraceOverride": {
              "marker": {
                "size": 5
              }
            }
          },
          "layout": {
            "xaxis": {
              "title": "HPL"
            },
            "yaxis": {
              "tickformat": "s",
              "nticks": 6,
              "title": "RTPL"
            }
          }
        },
        "elementStylers": ["selection-highlight"],
        "type": "plotly-scatter-plot",
        "mapping": {
          "xValues": ["[Measures].[Hypothetical PL]"],
          "yValues": ["[Measures].[Theoretical PL]"],
          "size": [],
          "splitBy": ["[Dates].[Date].[AsOfDate]"]
        }
      },
      "query": {
        "serverUrl": "",
        "mdx": "SELECT NON EMPTY {[Measures].[Hypothetical PL], [Measures].[Theoretical PL]} ON COLUMNS, NON EMPTY [Dates].[Date].[AsOfDate].Members ON ROWS FROM [PLSummaryCube]",
        "updateMode": "once"
      }
    }
  }
}
Subplots Example →