Help with Aggr Function

[RutiTaumanRubin]

Hi everyone,

I create Bar Char with dimensions: Region

The measure should be: avg of (Max(to_date)-max(start_date) group by to_category,from_category)

I try the following expression:

Avg(aggr(Max(to_date)-max(start_date)),to_category,from_category))

- But I didn't got any result.

This is strange because when I create a table with the dimensions: Region, from_category, to_category

and the measure : Max(to_date)-max(start_date) with type total - avg.

- I have got a results.

Could you please advise?

Thank you!

[sunny_talwar]

Try to add Region to your Aggr()'s dimension

Avg(Aggr(Max(to_date) - Max(start_date), Region, to_category, from_category))

[RutiTaumanRubin]

Thank you for your response.

I forgot to mention - I have more alternative dimensions..

[sunny_talwar]

Would you be able to share a sample?

[sasiparupudi1]

Avg(Aggr(Max(to_date) - Max(start_date), Region, to_category, from_category,alternative dim1,alternative dim2..))

[RutiTaumanRubin]

Thank you for your response-

It's bring different results when you grouped by more dimensions.

For example :

I want that when the user Choose dimension Region the calculate wil be:

Avg(Aggr(Max(to_date) - Max(start_date), Region, to_category, from_category)

when the user Choose dimension Geography the calculate wil be:

Avg(Aggr(Max(to_date) - Max(start_date), Gegraphy, to_category, from_category)

[sunny_talwar]

how are they choosing dimensions? is it from a list of island table entries?

[RutiTaumanRubin]

I just defined the dimensions as alternative and the following list is appear - The user should pick from the following list: