Knowledge Base Article

How to count down the months in the table | Linux

Our task is to show the count-down of the months/years/days in the widget.

Step-by-Step Guide: 

  1. We will use the solution from this article, steps 1-4 https://community.sisense.com/kb/faqs/create-a-plot-chart-with-a-month-over-month-comparison-of-the-values-linux/27709.
  2. Just our preparation finished, go to the dashboard and edit our widget.
  3. Add the value with the next formula (in our example, we are working with months, so we choose 12, if it will be years, we will choose the current year, f.e, 2025)
    12-avg([month])
  4. Press OK and enjoy the result

 

 

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.

Published 06-20-2025
No CommentsBe the first to comment