Just guessing: eazyBI imports data into the cube on a scheduled basis - so it’s not really real-time. It would be worth checking if this is the case. If you do need the data immediately you could kick-off the import manually, though it’s not a good practice to do so during office hours.
Ooops, sorry! I don’t know if I have a later version of eazyBI here in my Company, and I didn’t create this Calculated Member, but here is what shows up for me when I explored the Sprint dimension:
Aggregate(
Order(
Filter(
[Sprint].[Sprint].Members,
NOT [Sprint].CurrentMember.getBoolean(‘Closed’)
AND
NOT isEmpty([Sprint].CurrentMember.get(‘Start date’))
),
– ordering by start date across all boards
[Sprint].CurrentMember.get(‘Start date’), BASC
)
)
Perhaps, you could try this and let me know if it works? The logic looks OK to me.
@jimbok11 and @ssh, seem there are some formatting issues how quotes and dashes are represented after copying them to the community page and then back into eazyBI. There is the same formula without formatting (hopefully):
Aggregate(
Order(
Filter(
[Sprint].[Sprint].Members,
NOT [Sprint].CurrentMember.getBoolean('Closed')
AND
NOT isEmpty([Sprint].CurrentMember.get('Start date'))
),
-- ordering by start date across all boards
[Sprint].CurrentMember.get('Start date'), BASC
).item(0)
)
To be on the safe side, I would recommend copying a formula from eazyBI Demo account: https://eazybi.com/accounts/1000/cubes/Issues/
Look for Sprint dimension, calculated member Active Sprints.
Actually, found a different way of getting just Active Sprints (which seems to work!):
Aggregate(
Order(Filter(
[Sprint].[Sprint].Members,
NOT [Sprint].CurrentMember.getBoolean(‘Closed’)
AND
NOT isEmpty([Sprint].CurrentMember.get(‘Start date’))
),
– ordering by start date
[Sprint].CurrentMember.get(‘Start date’), BASC
)
)