Need to configure RUN TIME ANALYTICS

[Akilan]

Need to configure RUN TIME ANALYTICS we are getting two inputs from users, START_DATE and END_DATE.

1. END_DATE - By default it should be current date, and it should be editable.

2.Difference between START_DATE and END_DATE should be less than or equal to 15 days. if user select more than 15 days it should throw an error.

We referred Saviynt and forum documents but couldn't find much information.

[rushikeshvartak]

1. END_DATE - By default it should be current date, and it should be editable.  - Keep default value as blank during configuration 

2.Difference between START_DATE and END_DATE should be less than or equal to 15 days. if user select more than 15 days it should throw an error. - You need to show no records. You can’t show error messages on analytics 

[Akilan]

Difference between START_DATE and END_DATE should be less than or equal to 15 days. It's possible to configure this requirment in Run time.

[rushikeshvartak]

• No. In runtime you can't restrict but in query you can do

[NM]

Hi @Akilan , you can add a condition 

DATEDIFF(ENDDATE,STARTDATE) <=15

[Akilan]

Hi,
Thanks for the inputs.

DATEDIFF(ENDDATE,STARTDATE) <=15 this is working for 15 days or less.

1. END_DATE - By default it should be current date, and it should be editable.  I can't leave it empty ENDATE tab in runtime analytics. 

2) Is it possible to configure STARTDATE is (ENDDATE-7 )days by default .For example ENDATE should be current date(6-Aug-2024) and STARTDATE should be (30-Jul-2024). If the user want to change the STARTDATE and ENDDATE its should be editable and maximum date range is 15 day.

Expected Result should be like this (ENDATE is Current date and STARTDATE is ENDDATE-7 days)

Expected result Date difference is 15 days max.

Regards,

Akilan.

cant leave box empty 

[NM]

Hi @Akilan , can you add now() in default value

[Akilan]

Hi @NM ,

If i add now() in default value. It is showing this.

Regards,

Akilan.

[rushikeshvartak]

Default value is not supported for date