Last 15 days does not work

Questions & Answers
1

Hello,
I want to created a report that shows tickets created in the last 15 days. I thought it would be simple, copy the measure of last 30 days and change the number but it is not working. But I know there is data in those dates because the last 2 weeks filter works.
Works:

eazy1
eazy11584Ă—813 54.7 KB

Does not work:

eazy2
eazy2826Ă—538 20.1 KB

My code is:

Aggregate(
  [Time].[Month].DateMembersBetween('15 days ago', 'today')
)

I am not sure what is wrong.
Best

2

Hi @Lara_LG,

The Time dimension calculated member is defined to consider “Month” level members. A month member’s start date might not be within the set period of the last 15 days.

Change it to look for “Day” level members, and it will work. You can take the predefined calculated member “Last 30 days” as an example.

Best,
Roberts // support@eazybi.com

1 Like