Average time planned for the next 3 months

Hello community,

I have a question for you. Thank you in advance for your answers.

How to calculate the average time planned for the next 3 months?
I already get the planned time in tempo planner with eazybi.

Hi,
After you imported Tempo planned hours in eazyBI you can use them for average calculation, but please share more details about the expected average.
But what would you calculate the average for? (Users/ project / Periods etc)?
Here is the list of possible avearages I can read from your questioN:

Average tempo planned hours in next 3 months for the project.
Average tempo planned hours in next 3 months for the month.
Average tempo planned hours in next 3 months for the user.
etc.
Which is it then?

It would be great if you could illustrate the expected report (in a table view) with the results you would want to see in average calculation or explain how exactly you would calculate the average on one user/period/issue.

Martins /eazyBI

Hello Martins

Thank you for your answers.
I need to measure Average tempo planned hours in next 3 months for the user.

For example:
3 users (A,B,C). They have planned for the next 3 months:
A : 10h
B : 220h
C : 40h
Total: 270h

Avg: 270h/3 users= 90h

I tried this:
Measure 1: Total Number of members planned
NonZero(
Count(
Filter(
Descendants([Logged by].DefaultMember,[Logged by].[User]),
[Measures].[Tempo planned hours]>0
)
)
)

Measure 2: Tempo planner hours by user
([Measures].[Tempo planned hours],[Logged by].CurrentHierarchyMember)

Measure 3: Avg planned hours
[Measures].[Tempo planner hours by user]
/
[Measures].[Total Number of members planned]

@Nanangoran

Try this formula:

Avg(
Filter(
Descendants([Logged by].DefaultMember,[Logged by].[User]),
[Measures].[Tempo planned hours]>0
),
[Measures].[Tempo planned hours]
)

if that didn’t work, please share more details on the layout for the report. What dimensions would you use as rows/columns/page filters.

Martins / eazyBI

Hello;
Dimension: Custom field service (A,B,C,B) and user
Measure: Tempo planned hours by user country (FR, GH, CI, TN)

Can you explain to me where do I used the formula of your previous post ?

Merci

Hi,
This formula should be used when creating new user-defined calculated measure.
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures

Martins / eazyBI

Hello

please see this attachment.

I’am remaining available

@Nanangoran
Doesn’t this code already do what you expect?

Avg(
Filter(
Descendants([Logged by].DefaultMember,[Logged by].[User]),
[Measures].[Tempo planned hours]>0
),
[Measures].[Tempo planned hours]
)

Martins / eazyBI

1 Like

Thank you so much.
Your formula is good after making control.