Forecasting support has been added with trend and regression lines. Other new features include chart linking, time series hierarchies, and ad-hoc data comparison and profiling. This is the first in a series of blogs that will explain the strengths and weaknesses of each of these and how to use them within Lumira Discovery. This blog will take a look at the new feature providing ad-hoc data comparison and profiling.
Ad-hoc Data Comparison and Profiling
Emphasizing the “discovery” capabilities of Lumira Discovery, SAP has added the functionality for ad-hoc data comparison and profiling. This feature allows you to take certain charts and do quick analysis of the data on the fly. This feature isn’t available for all charts at this time.
The example that I will show is a simple bar chart that illustrates sales by year. As I mentioned, not all charts will work with this new feature. For instance, I tried to do this exercise with a stacked bar chart and it did not work, you need to have a single measure. When performing ad-hoc data comparison, this feature provides different statistics such as the sum, average, max, min, and median for whatever parts of the chart that you choose.
The first step is to create a simple bar chart:
Once you’ve created your bar chart, it’s important to maximize the chart and right click in the chart area to enable Ad-hoc Data Comparison:
Now that you’ve enabled this, you can start using the functionality. When maximized on the chart or in preview mode, the first thing to notice (and it’s easy to miss) is by selecting one bar and then a second bar you immediately get a nice variance line:
You can now easily compare two items to see the variance.
Next, click and drag to highlight whatever portion of the chart you’d like to analyze. For this example, I will highlight 2001 and 2002:
After highlighting 2001 and 2002, Lumira automatically brings up the box showing the statistics of the data that you highlighted. As you can see, it provides the sum, average, max, min, and median.
In addition to this first screen, you can click the arrow to see more:
The next screen shows a Tag Cloud of your data:
Wrapping it up
These are the basics of how to use the new feature ad-hoc data comparison and profiling in Lumira 2.1. Remember to maximize the chart when you are designing to enable this feature, it really adds a lot of analytical value to your data visualizations. If you like this and want to take the concept further, you can import into Lumira Designer and create your own dynamic pop up features – but “out of the box” this is a very good starting point.