__manufacturing-2-image-unique-image-unique

__manufacturing

<h4>To install the Filtered Measures add-on:</h4>
<ol>
<li style="font-weight: 400;" aria-level="1">If you’re running Sisense on Windows:
<ol>
<li style="font-weight: 400;" aria-level="2">Download the attachment </li>
<li style="font-weight: 400;" aria-level="2">For windows: xtract 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 style="font-weight: 400;" aria-level="2">After those files have been unzipped there, you may also have to restart the web server.</li>
</ol>
</li>
<li style="font-weight: 400;" aria-level="1">If you’re running Sisense on Linux, this add-on is pre-installed, so you can just enable it in the Admin &#8211; Add-ons section.</li>
<li style="font-weight: 400;" aria-level="1">Open your data model in the Data tab and 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. Name the new field Date2<img decoding="async" loading="lazy" class="aligncenter size-large wp-image-741624" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_1-1024x578.png" alt="" width="1024" height="578" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_1-1024x578.png 1024w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_1-300x169.png 300w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_1.png 1600w" sizes="(max-width: 1024px) 100vw, 1024px" /><img decoding="async" loading="lazy" class="aligncenter size-full wp-image-741625" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_2.png" alt="" width="615" height="446" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_2.png 615w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_2-300x218.png 300w" sizes="(max-width: 615px) 100vw, 615px" /></li>
<li aria-level="1">Add two dashboard filters for the fields created in the previous step<img decoding="async" loading="lazy" class="aligncenter size-full wp-image-741626" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_3.png" alt="" width="496" height="581" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_3.png 496w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_3-256x300.png 256w" sizes="(max-width: 496px) 100vw, 496px" /></li>
<li aria-level="1">Create a pivot table that calculates Total Cost per Category and apply the dashboard filters created in the previous step. Duplicate a Total Cost measure. You should have something similar to this 
<img decoding="async" loading="lazy" class="aligncenter size-large wp-image-741627" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_4-1024x541.jpg" alt="" width="1024" height="541" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_4-1024x541.jpg 1024w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_4-300x159.jpg 300w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_4.jpg 1600w" sizes="(max-width: 1024px) 100vw, 1024px" /></li>
<li aria-level="1">In the Total Cost formula editor, add the Years in Date field to the formula. 
<img decoding="async" loading="lazy" class="aligncenter size-full wp-image-741628" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_5.png" alt="" width="725" height="951" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_5.png 725w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_5-229x300.png 229w" sizes="(max-width: 725px) 100vw, 725px" /></li>
<li aria-level="1">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. In our case it will be “@Year 1” 
<img decoding="async" loading="lazy" class="aligncenter size-large wp-image-741629" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_6-1024x204.png" alt="" width="1024" height="204" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_6-1024x204.png 1024w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_6-300x60.png 300w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_6.png 1147w" sizes="(max-width: 1024px) 100vw, 1024px" /></li>
<li aria-level="1">Rename the field with a meaningful name (for example: Year1 Cost). 
<img decoding="async" loading="lazy" class="aligncenter size-full wp-image-741630" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_7.png" alt="" width="902" height="480" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_7.png 902w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_7-300x160.png 300w" sizes="(max-width: 902px) 100vw, 902px" /></li>
<li aria-level="1">Repeat the steps 6-8 for the second measure item &#8211; Total Cost (1) but for the Date2 field filter 
<img decoding="async" loading="lazy" class="aligncenter size-large wp-image-741631" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_8-1024x632.png" alt="" width="1024" height="632" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_8-1024x632.png 1024w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_8-300x185.png 300w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_8.png 1075w" sizes="(max-width: 1024px) 100vw, 1024px" /> 
</li>
<li aria-level="1">Now the “Year1 Cost” column is affected by the “Year 1” filter and “Year2 Cost” column is affected by the “Year 2” filter. 
<img decoding="async" loading="lazy" class="aligncenter size-large wp-image-741632" src="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_9-1024x597.jpg" alt="" width="1024" height="597" srcset="https://cdn.sisense.com/wp-content/uploads/Filtered-measure_9-1024x597.jpg 1024w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_9-300x175.jpg 300w, https://cdn.sisense.com/wp-content/uploads/Filtered-measure_9.jpg 1600w" sizes="(max-width: 1024px) 100vw, 1024px" /></li>
</ol>
&nbsp;

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.

Leave Feedback