Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Current Week "created date vs resolved date" reports

Rohith June 3, 2019

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.

image.pngimage.png

Thanks,
R.K

1 answer

1 accepted

1 vote
Answer accepted
Ilze Leite-Apine - eazyBI
Atlassian Partner
June 13, 2019

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

support@eazybi.com

Rohith June 13, 2019

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?image.png

Suggest an answer

Log in or Sign up to answer