Different business demands require different skills and techniques to quickly and substantially respond to them – talking from a data perspective. Having the ability to quickly build data solutions to many of the organization business questions can make your work as a data analyst smooth. But, to amass the necessary skill and speed to respond to these changing business needs requires some serious investment in learning. That’s why this article is part of the small skills of the bigger skill.
Have you ever been tasked to compute the contribution of certain members or data points to the whole? And do it in such a way that the end user has flexibility to choose which particular members or data points to use when computing.
The solution – Using set action
Why set action?
A Set is always divided into two – IN/OUT set.
With this, we can create a set action that captures end user selection on the dashboard to form now the IN set which will be used in our calculation.
Step by step guide
We’ll be using data on ‘Traffic Incidences’ in Kenya, to show contribution of a County or a group of Counties to the total number of deaths or injuries recorded countrywide in the year 2011.
(In your own business set-up, you will find other scenarios where this technique can be applicable)
Create a map showing distribution of accident Victims
Drag dimension field County to details shelf – Note: Assign geographical role of this field as a State/Province.
Drag measure field Victims to the color shelf.
Create a set consisting a couple of counties
Create a pie chart computing the proportion of deaths resulted from the counties we’ve selected above.
Select Pie under marks card
Drag measure field Deaths to the Angle
Drag our set County set to the color
Label the view and compute the percent of total
Repeat the step above but now using the field – Injured to compute the proportion of Injured resulted from the IN set.
Combine the three views in a dashboard as show below
This dashboard is somehow static, this is because the computation on proportion of deaths and Injured is based on a fixed set, we therefore need to create a set action to enable change of IN set based on user selection on the dashboard.
To do that;
Go to Dashboard menu >> Actions…
Executing this leaves us with a more flexible & informative view. Computing contribution of a county or a group of counties to the total is a simple as selecting a portion of the viz.
I hope this was helpful to you.
To receive more of these, tips and tricks for data visualization. Subscribe to our emailing list and you’ll be the first to know.
Thanks for reading.