Filer issues "Time between 20 days ago and today"

Hi,

  • Formulae on Reporting structure “Time between 20 days ago and today”, Is there a way to get this in EazyBI.Perday count of issues.

Can you please give me a measure code.

thank you!!
Regards,
Manoj

Hi @manoj_reddy,

When you have Time dimension with the day level selected on rows, you can click on any of the members and add filter between 20 days ago and today.

Another option is to create a calculated member in Time dimension that will aggregate the date members in the period:

Aggregate( 
  [Time].[Day].DateMembersBetween('20 days ago', 'today') 
)

Lauma / support@eazybi.com