__manufacturing-2-image-unique-image-unique

__manufacturing

<h4>To install the Filtered Measures add-on:</h4>
<ol>
<li>Download the attachment.</li>
<li>Extract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file. 
For V7.1 and earlier: C:\Program Files\Sisense\PrismWeb\plugins 
For V7.2 and later: C:\Program Files\Sisense\app\plugins</li>
<li>After those files have been unzipped there, you may also have to restart the web server.</li>
<li>In the ElastiCube Manager, duplicate the field that you want to perform a comparative analysis on. For example, duplicate the Date field within the ElastiCube to compare values for two years. 
<img loading="lazy" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/duplicate_thumb_0_300-370x164.png" alt="" width="370" height="164" /></li>
<li>In the Sisense Web Application, add these duplicated fields created in the previous step as filters, for example, if you are using dates, you can create filters as Year 1 and Year 2. To learn how to create filters, click here. 
<img loading="lazy" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/pivot1_thumb_0_3001-370x174.png" alt="" width="370" height="174" /></li>
<li>Create a pivot table that calculates Revenue per Category and apply the dashboard filters created in the previous step. 
<img loading="lazy" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/pivot1_thumb_0_300-370x174.png" alt="" width="370" height="174" /></li>
<li>In the Revenue formula editor, add the Years in Date field to the formula. 
<img loading="lazy" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/years_thumb_0_300-370x192.png" alt="" width="370" height="192" /></li>
<li>Change the name of the field to the name of the required filter (that is, the one you want to affect the value) and add ‘@’ symbol before it. 
<img loading="lazy" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/rename_thumb_0_300-370x194.png" alt="" width="370" height="194" /></li>
<li>Rename the field with a meaningful name (for example: Year 1 Revenue). 
<img loading="lazy" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/rename3_thumb_0_300.png" alt="" width="280" height="300" /></li>
<li>Repeat steps 5-7 for Year 2. Year 1 Revenue column is affected by the Year 1 filter and Year 2 Revenue column is affected by the Year 2 filter. 
<img loading="lazy" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/pivot3_thumb_0_300-370x268.png" alt="" width="370" height="268" /></li>
<li>To create a Growth calculation, simply use the following syntax: Once you create the Growth measure, you can use it in a numeric indicator and bar chart. 
<img loading="lazy" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/filtermeasures_thumb_0_300-370x298.png" alt="" width="370" height="298" /></li>
</ol>

filters_the_different-image-unique

filters_the_different

filters_the_same-image-unique

filters_the_same

Widgets

advanced filtering

HIPAA

By default, filter selections in Sisense can be defined on the dashboard or widget level. The Filtered Measure add-on makes it possible to create additional selection states. This means that you’re able to show two (or more) different sets of selections in a single widget.
This feature is useful when you want to perform comparative analysis. For example, an eCommerce agency needs to create a dashboard that provides sales analysis across years. One of the main purposes of the dashboard is to compare sales of their categories in different years. To provide side-by-side comparisons that analysts can change dynamically, you can create two different filters: Year 1, and Year 2. These filters will represent two different year selections that can be changed by the user.

Filtered Measure

Marketplace Detail Template

Leave Feedback