How to count down the months in the table | Linux
Step-by-Step Guide:
- 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.
- Just our preparation finished, go to the dashboard and edit our widget.
- 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]) - Press OK and enjoy the result
![Table shows "Months in Date" with two rows: November 2009 with value 1 and December 2009 with value 0 in the "12-avg([month])" column.](https://res.cloudinary.com/startup-grind/image/upload/c_fill,dpr_2,f_auto,g_center,q_auto:good/v1/gcs/platform-data-sisense/discussions/bS0yNzkwOS02OG9vZ1I_VUN9uMd)
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.
0 comments
