Sum for new date

[AveryLeerling]

Hello,

Does someone know if in the reporting there is an fx that can calculate an new date, so as I can make in excel =date(today + 21 days) 

= 21-june-2024

is that possible can someone help me?

[david-h · Accepted solution]

Hi,

It depends on what you want to achieve.

If you need to display a date + or - X days, it does not exist out of the box in Sisense. You can always use a Javascript script in your widget to do this.

If you want to get the value of a KPI for date + or - X days, you can use the time windows functions : pastyear/pastmonth/pastweek/pastday or next and prev that can be used to get the KPI value at a relative date.

For example, the values of Revenue 21 days ago you can use : ([Total Revenue],prev([Days in Date],21)). This will give the Total Revenue 21 days before the date in the current context.

Best, David

[david-h · Accepted solution]

Hi,

It depends on what you want to achieve.

If you need to display a date + or - X days, it does not exist out of the box in Sisense. You can always use a Javascript script in your widget to do this.

If you want to get the value of a KPI for date + or - X days, you can use the time windows functions : pastyear/pastmonth/pastweek/pastday or next and prev that can be used to get the KPI value at a relative date.

For example, the values of Revenue 21 days ago you can use : ([Total Revenue],prev([Days in Date],21)). This will give the Total Revenue 21 days before the date in the current context.

Best, David

[AveryLeerling]

Hi,

Well, we register a date and let's say an action has been placed on 31-5-2024 and we need to know the date of plus 21 days. From that registrated date, because then the next thing in the process needs to get started. But with the available fx I can't find a why to visualize it in that way. We have about a hundred points in time that needs this calculation and I'm not ganno do it by hand haha. THere must be a way to do this, computersystems are smart enough for that I guess.

regards Avery

[david-h · Accepted solution]

Hi Avery,

For your use case I think you should do the calculation in the datamodel. It seems to be more a process calculation, and you will be able to visualize it in the dashboards.

You can add a calculated column, DueDate, defined as adddays([RegisteredDate], 21)

Best, David.

[DRay]

Hello @AveryLeerling ,

I wanted to follow up to see if the solution offered by @david-h worked for you.

If so, please click the 'Accept as Solution' button so other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.

[DRay]

Hello @AveryLeerling ,

I wanted to follow up to see if the solution offered by @david-h worked for you.

If so, please click the 'Accept as Solution' button so other users with the same questions can find the answer faster. If not, please let us know so that we can continue to help.

Thank you.