Situation where the dataset contains multiple fields that could be used for comparison or for measure presents a challenge for the analyst creating the report. How can someone predict whether the recipient is more interested to compare the products, categories or brands and measure the sales by number of units sold, $ value, or the weight shipped?

One option is to create multiple variations of the same chart, using the different combinations of split and measure fields. Omniscope offers a solution to avoid the dashboard overload like that and give the end user control over the proceedings: scenario where the person 'consuming the report' is given the choice and is able to do it all on one Omniscope tab.


The demo here is showing how interaction and choice of split/measure field is affecting three different charts on a single tab, avoiding the need to duplicate the work. 


We can achieve this by creating the split and measure formula fields in the Report Data Sources area:


Open the target Report block in Omniscope Evo workflow > click Present button > Report Data Sources 


On the Sources tab add the Formula block (fx) next to the data source block that contains the filter and measure fields.


On the Variables tab create your variables and give them name e.g. [Split choice] and [Measure choice], then add choice values, like in the image below: "Type", "Pack", "Brand". In this case we're using a text variable, but Omniscope will also allow you to use integer, decimal or date values. 


In the formula editor add an IF formula with syntax such as:

IF (

[Split choice]='Type',[Type],

[Split choice]='Brand',[Brand],

[Pack])



Note that your Variable display values can but don't have to contain the exact field names - you can use different wording, if the original field name is too long. This will work as long as you match in the formula syntax the exact spelling of both the [Variable] and the [Field name].

Finally - make sure that you add the Filter devices with exposed split/measure Variables, so the end user can interact with them and switch between different comparison scenarios.