Calculation error for date parameter custom selection

Question & Answer
,
1

image
image1252×640 37.3 KB

Hi Team, can you please help me out the above error

2

Hello @Alam_Syed

You are adding conditions in the wrong places and mismatching the data types. Can you breakdown what you are trying to get this calculated field to do?

For reference, in the conditional logic you will want to add the condition and then expected result. Your expected results also need to be the same data type.

3

Hi @duncan Thanks for the reply.

I am looking for a custom date selection like Last 7 Days, Last 30, Last 60 Day, Last 90 Days

I have a Date column data type, datetime

4

Hello @Alam_Syed

You need to change the logic in your current calculated field and change how you are filtering. For example:

ifelse
	{Date} >= addDateTime(-7, 'DD,{Date}) AND {Date} <= now(), 
		'Last 7 days',
	etc..,
	Null
)

Then link your parameter to that field as your filter.

1 Like
5

Awesome, I made similar to this and its work for me. thank you so much.

1 Like