Set Analysis allows you to provide more context to your data. For example, if you just display the sales value for a specific month, it is good information, but it is not actionable. If you compare this value against the same month last year, you have added context to the value. The user can then get more value out of the report or dashboard by starting to look at trends.
Set Analysis was introduced in Yellowfin v7.3 and basically pre-defines a set of data that your charts can use. Using Set Analysis, we can display values corresponding to various sets of data (e.g. a specific time-period, country or category, etc.). In earlier versions this had to be done using sub-queries which required more technical skills.
Let me explain this by using a couple of examples.
Example 1
In the first example we will be comparing the sales for 2017 with the sales of 2016 using two number charts.
Create a new report based on the Ski-Team view. This is part of the tutorial content that can be installed when installing Yellowfin.
Add the Year, Athlete Region and Invoice Amount fields to the columns area.
Proceed to the Charts step.
Drag the Set Analysis Function to the Horizontal axis.
In the pop-up window, give your new set a name and set the metric to Sum Invoiced Amount.
Select Year in the Select Filter Field dropdown and set the year to 2017.
Click on Submit.
You will now have a number chart with the sales value for 2017.
Create a copy of this chart by hovering with your mouse over the chart thumbnail in the Chart list at the bottom of the screen. Select Copy from the menu.
Click on the 2017 Sales set in the horizontal axis and select Configure Set.
Change the name of the set to 2016 Set and update the filter value to 2016. Click on Submit.
Proceed to the Design Step and build your visualization using the multi-chart canvas.
Example 2
In the steps below we will be comparing the sales between the North America and Europe regions by Year. To achieve this, we will create two sets of data (Set Analysis functions), one for the sales in the North American region and another for the sales in the Europe region.
Go back to the Charts step and remove both charts. You can do this by hovering on the chart thumbnail at the bottom of the screen and selecting Delete.
Click on Auto Chart and select a Line Chart.
Set the Horizontal Axis to Year.
Drag the Set Analysis Function to the Vertical axis.
In the pop-up window, give your new set a name and set the metric to Sum Invoiced Amount.
Select Athlete Region in the Select Filter Field dropdown and set the value to North America.
Click on Submit.
Drag another Set Analysis Function to the Vertical Axis.
In the pop-up window, give your new set a name and set the metric to Sum Invoiced Amount.
Select Athlete Region in the Select Filter Field dropdown and set the value to Europe.
Click on Submit.
The chart will display with a line for each of the regions’ sales by Year.
Next, we want to change the color of one of these lines in order to differentiate between Europe and North America.
Click on the Europe set in the vertical axis and select Settings.Change the Style too Solid and enable Custom Color.
Select a color from the color selector.
Click on the X at the top right to close the settings window.
Your chart should look like the image below.
By following the same methodology, you can set up more meaningful and actionable visualisations.