cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
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.

Solution:  

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
image2016-11-10_22-12-16.png
image2016-11-13_11-29-54.png
Version history
Last update:
‎03-02-2023 08:29 AM
Updated by:
Contributors
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: