I am planning to get "created date vs resolved date" EazyBI reports for the current week, where I have taken TIME in ROWs with calculated measures as weekly
Aggregate(
Filter(
[Time.Weekly].[Week].Members,
DateBetween([Time.Weekly].[Week].CurrentMember.StartDate,'1 weeks ago','today')
))
Supposed to get only values of the current week(i.e, last 7days from today). But in my reports, we are getting a few extra values.
sharing my screenshot that might help you. In second Image RED highlighted shouldn't appear.
Thanks,
R.K
Hi, Rohith,
You are already there: you may try modifying the Time Weekly calculated member and aggregate Day level members instead of Week level members as well as use "7 days" instead of one week ago:
Aggregate(
Filter(
[Time.Weekly].[Day].Members,
DateBetween([Time.Weekly].[Day].CurrentMember.StartDate,'7 days ago','today')
))
Ilze, eazyBI Customer Support Consultant
Thanks for your response. Anyways I figured it out using
Aggregate(
Filter(
[Time].[Day].Members,
DateBetween([Time].[Day].CurrentMember.StartDate,'7 days ago','today')
))
I have one more question in view LINE vs TIMELINE
In Line view reports are showing exactly for the last 7days. In Timeline it's showing the same reports but viewing more dates than required. How do I remove useless dates?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.