Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am trying to create an expression that only shows the current year to date data in a Pie Chart for an element that has a status of 'On-Time'. Below is the used expression which presents me with a 'No data to display' error.
=Count({1<[Actual Revision Completion Status]={'On-Time'}, [Next Scheduled Effective Date] = {'$(=Year(Today()))'}>}[Actual Revision Completion Status])
I do have a Year field in my script and the Next Scheduled Effective date is in a date format.
Any help would be appreciated!
Thank you,
Dylan
Hi, I think the best option here is to create a [Next Scheduled Effective Year] in script using Year([Next Scheduled Effective Date]), so you can use this field in set analysis.
Another option may be using something like: [Next Scheduled Effective Date] = {"*/$(=Year(Today()))"}, it assumes than date is in DD/MM/YYYY or MM/DD/YYYY format.
Have you tried doing the Year of the date equal to this year
Do you have a master calendar? I would just use the year from that because right now you are comparing a date to a year.
Let me know if I am reading your question wrong.