Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Kindly suggest me whats wrong with this statement?
i am getting invalid statement.
=min(If(Match(task_name,'Upload Content') and Match(workflow_name,'EMEA Content Upload and perform QC'),date(task_creation_date), '31/12/2025'))
thanks,
Even below will return same result
=If(Match(task_name,'Upload Content') and Match(workflow_name,'EMEA Content Upload and perform QC')
,min(date(Date)), makedate(2025,12,31))
or
=if(
min({<task_name={'Upload Content'},workflow_name={'EMEA Content Upload and perform QC'}>}task_creation_date)
,min({<task_name={'Upload Content'},workflow_name={'EMEA Content Upload and perform QC'}>}task_creation_date)
,makedate(2025,12,31) )
There does not appear to be anything wrong with this statement. It parses correctly in Data Load Editor.
Above statement is valid, but make sure the FIELDS you are using in this expression are correct.
yes but when i add the min function its giving me invalid in the report expression, otherwise wihtout min its working fine. i got 3 lines of dates. wanted to take min of these dates.
Your issue is probably with using a string within the min() function. Try using a date instead of the string in the Else section.
Can you help with few lines of dummy data , it will help others is giving solution to your problem.
i tried instead of string following:
=min(If(Match(task_name,'Upload Content') and Match(workflow_name,'EMEA Content Upload and perform QC'),date(task_creation_date), makedate(2025,12,31)))
still its saying invalid statement
Even below will return same result
=If(Match(task_name,'Upload Content') and Match(workflow_name,'EMEA Content Upload and perform QC')
,min(date(Date)), makedate(2025,12,31))
or
=if(
min({<task_name={'Upload Content'},workflow_name={'EMEA Content Upload and perform QC'}>}task_creation_date)
,min({<task_name={'Upload Content'},workflow_name={'EMEA Content Upload and perform QC'}>}task_creation_date)
,makedate(2025,12,31) )
thanks its working correctly with my statement but i had to put this expression in the measure instead of dimension. but i have achieve result like following:
here the left side less than 3 days , 3-5 days this grouping is the dimension i wanted to count by above duration expression.
actual result i am getting now:
expected result:
thanks,