Showing results for 
Search instead for 
Did you mean: 
Community Team Member
Community Team Member
Below gives a solution on how to compare this year results up to today with previous year until the same parallel day.


If you want to compare this year and the previous year you can add a widget filter where you will choose the current day (or a specific day)
  1. Function: PastYear(YTDSum([Total measure]))*
  2. Widget filter-today (keep in mind if you do not have value for today you will not get results)
  • If you want to compare to 2 years ago (YTD), use the Past year function again and wrap the entire function
Version history
Last update:
‎03-02-2023 08:29 AM
Updated by:
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: