Welcome to the next blog in this series covering what’s new in SAP Lumira 2.1. In the previous blog, we covered the capabilities of Ad-hoc Data Comparison and Profiling. This is a great new feature for performing quick analysis on the fly.
Now, let’s look at the new chart linking feature, which in Lumira Discovery is called Linked Analysis.
Chart linking is a much-anticipated new feature that has been added to Lumira Discovery, which you could previously only do in Lumira Designer. This feature allows you to link multiple charts, so that when you click, for example, on a Crosstab it will, in turn, filter your bar chart based on the value you clicked.
This new feature helps create a more interactive view of your story and allows the user to see the data at different viewpoints by a simple click of the mouse. When using this feature, you can pass the selection of your source chart to single- or multiple-target visualizations. Keep in mind that Linked Analysis is not currently supported for geo maps, however, all other charts are supported.
In this example, the first step is to create a simple crosstab, bar chart, and pie chart:
Next, we want to make our Crosstab as our source for the Linked Analysis. Right-click on your Crosstab and click Linked Analysis.
From here you can select the dimension that you want the two charts to be linked on. For this example, we will select Year. You also need to select your target visualization(s), which in this case we will select the checkboxes for the bar chart and pie chart.
Note: The source crosstab checkbox is greyed out as a possible target.
When you go to the preview of your story, you can see that nothing is filtered yet, so all visualizations are showing the data for all years.
If you click on the value 2015 in your Crosstab, you can see that your charts are automatically filtered to the data only in the year 2015.
Similarly, if you want to see the data for 2016 you simply click on the value 2016 in the crosstab and you will see that the charts adjust again based on your selection in the crosstab.
Wrapping it up
These are the basics of how to use the new Linked Analysis feature. Similar to the ad-hoc data comparison feature, if you want to take this to the next level, you can take this into Lumira Designer and create all of the custom “on-click” functionality that you want for your dashboard.
Look for future blogs on some of the other new features in Lumira 2.1.
Andrew has more than 7 years of experience and specializes in the EIM field, with a solid background in front end as well. He has strong experience with SAP HANA, Data Services, Information Design Tool, Lumira, Crystal Reports and Web Intelligence. He has worked in a number of industries such as Retail, Energy, Manufacturing, and Healthcare with direct experience working with two Fortune 100 companies. Andrew enjoys playing and watching sports, being outdoors, and traveling in his free time. When he’s not busy pulling for the Atlanta Sports teams you can reach him at Andrew.Johnson@kingfisherinc.com.