Show categories calculation for another year which have no data in this year | Linux

 

 

In the widget, we want to see the categories with data in 2025 and 2020.

If we use the filter for 2025, we will see just the values for the year 2025

 

And our task here is to show data for the years 2025 and 2022

Step-by-Step Guide: 

1. Go to Admin - Server & Hardware - Add-ons.

2. Enable the plugin filteredMeasure with the toggle on the right:

 

 

3. Wait until the float window appears and press the OK button.

4. Go to the dashboard and create a widget with Rows and the necessary years in Values

 

 

5. For the 2025 (which value we have as a filter on the dashboard), make such a formula
(sum([Total Sum]), [Years in date])

6. Press on [Years in date] and rename it to [@Years in date], press the OK button.

 

 

7. For the year 2020, make the same formula 
(sum([Total Sum]), [Years in date])

8. Press on  [Years in date] and Edit filter and select the year 2020. Press the Apply and OK buttons

 

9. As a result, we will get the next widget

 

 

Conclusion: 

This solution can help you to show all the years in the widgets.

Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before deployment. If you need further assistance with this, please let us know.