Use year from the 0001 till today | LIVE | [Linux]

Step-by-Step Guide: 

1. Open your live model, 3 dots - Connection settings - Change table.

1. Your query looks like:
   
   SELECT * FROM "PUBLIC"."MY_DATE_TABLE"
   
   
2. Modify it by adding at the beginning:
   
   SELECT DISTINCT TO_CHAR(date, 'YYYY') AS year, * FROM "PUBLIC"."MY_DATE_TABLE"
   
   
3. Press the Parse and Done buttons
4. Publish Live model by pressing the Publish button
5. After this, you can use this column to show the years and filter them

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.