Filter on time and have the month day for day

Questions & Answers
, , ,
1

Hello;

Is there the possibility in eazybi to make a filter on the time whose selection for 2 months, will give a measurement going from the date of the day until the date of this same day for 2 months?

For instance:
I want to have the number of planned times over the next 2 months.

Today is 11/18/2022. the filter that I am looking for will have to give me the planned times for 2 months from 11/18/2022 to 01/18/2023.

Thank you for your help.

2

Hello @Nanangoran,

Welcome to EazyBI community!

EazyBI Time dimension allows you to create various combinations for time filtering. You might find this information useful when learning more about relative dates - Date filters

To create 2 months ago time period, you can define a new calculated member in your Time dimension. You can Aggregate several Time dimension members with a formula like this:

Aggregate(
[Time].[Day].DateMembersBetween('2 months ago', 'today')
)

Let me know if this helps!

Best wishes

Elita from eazyBI@support.com

3

Hello

Thanks for your feedback. After the test, it is rather the opposite that works well. that’s to say:
Aggregate(
[Time].[Day].DateMembersBetween(‘today’, ‘2 months from now’)
)

4

@Nanangoran Thanks for following up! I apologize for missing the future part, however, I am glad you were able to make it work!

1 Like