This post describes how to create variable dimensions and measures for a scatter plot and use the selections to track down different correlations.
Requirements:
Measure Changer Plugin
Measure Changer Plugin
Trend Line (Menu Based Plugin)
Many times it may be tough to identify correlations between different metrics in a business. This is due to the number of different dimensions, components and variables inside a business. In conjunction with the associative filters between widgets, the above chart is designed to allow the user to compare different KPI's across whichever dimension the user selects.
The objective is to allow end users to take a deeper dive into the insights their dashboard provides. For example, a manager is looking for a correlation between product sales to explain why their top sales person does so well. She can select her top salesperson and then browse through the different metrics; revenue, cost, discount amount, profit %, etc. Then they can compare the rest of their sales and see how it changes.
In order to create this chart you need to add the following plugins
Once installed, create a scatter plot, add a single dimension X-Axis metric, and y Axis Metric. It is optional, but you can set the trend line and display the equation.
The next step is to set up the measure changers and dimension changer. Lets begin by creating the X-Axis Measure changer. Create a new widget and select dimension changer, add all the measures you want to switch between under 'values'. Apply the changes, edit the widget again, and open the script editor from the widget menu in the top right corner. Paste the following code into the script editor, save it, refresh the widget, and click apply.
widget.on('render',function(w,e){
e.prefixText='Switch Between -';
e.widgetIds = [
{ id:'5bad1507329aee1ecc4575b2', panelToChange:'x-axis', index:0}
]; });Next Duplicate the widget for the y axis and paste the following code. Make sure to change the widget ID's in both code snippets.
widget.on('render',function(w,e){
e.prefixText='Switch Between -';
e.widgetIds = [
{ id:'5bad1507329aee1ecc4575b2', panelToChange:'y-axis', index:0}
]; });Finally, we need to create a 3rd dimension changer widget to control what the points represent. This time we are going to add all the dimensions under 'Rows'. We are going to want to use the following script.
widget.on('render',function(w,e){
e.prefixText='Switch Between -';
e.widgetIds = [
{ id:'5bad1507329aee1ecc4575b2', panelToChange:'point', index:0}
]; });You are left with a scatter plot where the end user can manipulate the dimension and measures to gather further insight.
