I want to create an aging report providing me with the last time when someone assigned their Tempo time to an account so that we can determine if the account can be closed.
I’m still a novice, but it seems to me that I need to created a calculated member to first identify the last Tempo time date for each issue and then another to compare these results for all the issues related to the Account and select the MAX date among this result.
My attempt in using the following calculated member for the first part of this query is accepted, but yields no results:
TimestampToDate(
Max(
Filter(
Descendants([Issue].CurrentMember),
[Measures].[Issues with Hours spent]>0
),
DateToTimestamp([Measures].[Hours spent])
)
)
Any help would be appreciated.