The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Issue filter for Open issues with start date < today

Rohith reddy
April 11, 2023

Hello,

I used this script but getting error as below. Can anyone help me out?

Sum(Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
[Measures].[Issue start date] < [Measures].[Today]

),
[Measures].[Issues created]
)

#ERR: mondrian.olap.fun.MondrianEvaluationException: Expected value of type NUMERIC; got value ‘Wed Jul 07 00:00:00 UTC 2021’ (DATETIME)

and i tried this script and getting an error for this script

Sum(Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
[Measures].[Issue start date] < [Measures].[Today]
AND
[Measures].[Open issues]
),
[Measures].[Issues created]
)

Error - Formula is not valid:
No function matches signature ‘ AND ’

Thanks
Rohith

0 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

TAGS
AUG Leaders

Atlassian Community Events