Calculated an average by month where the dimension is hour

[#1]

Hello to all comunity members,

Having the table below:

I want in a chart expression calculate BY hour the average BY month of Sales/Number of stores. Can any help me to formulate the right expression?

Best regards

[Gysbert_Wassenaar]

Create a straight table object and use Month as dimension and avg([Number of stores]) avg(Sales) as expressions

[#3]

Even if I want to display values by hour not by month?

[#4]

What I did is that I created a chart, I then choose Hour as a dimension and put the following expression:

Aggr(Avg(Sales/Number Of Stores),M)

But I had no displayed data

[Gysbert_Wassenaar]

Please post the result table you expect.

[#6]

I gave an example of how I want to calculated the average that I want to calculate. Maybe I didn't explain well what I wanted, sory for that

[Gysbert_Wassenaar · Accepted solution]

Try avg(aggr(sum(Sales)/max([Number of Stores]),Month,Hour))

[#8]

Accurate answer as always, many thanks Gysbert.

Best regards,

Yasser.