Expressions with different dimensions in same chart

[#1]

Hello everbody,

I wanted to know if it is possible in a line chart to have two expressions with different dimensions ?

Common dimensions : Period

1st expression : average of marks by period and by country

2nd expression : average of marks by period for all countries

Thank you

[#2]

Hi!

Well, you can achieve that particular effect by making having Period as dimension and then add an expression for each country and an expression for all the countries.

Example:

Expression 1

avg( {<Country{"USA"}>} Marks)

Expression 2

avg( {<Country{"UK"}>} Marks)

Expression 2

avg( {<Country{"*"}>} Marks)

This will show a line for each country and an average for all the countries.

Hope it help!

/Regards

[#3]

The problem is that I got numerous lines...

[masha-ecraft]

You can try the following:

Chart dimension: Period

1st expression: Avg(Marks)

2nd expression: avg(aggr(avg(Marks),Period, Country))

/Masha

[#5]

I got something very strange :

[masha-ecraft]

Please add Period dimension to the list of aggregate parameters:

avg(aggr(avg(Marks),Period, Country))

[#7]

I tried but it still not working. I don't have my average by country but a global line...

[#8]

Hi,

Could you add an example where your solution is working? I would appreciate it alot since it would be neat to reduce the hardcoding

/regards

[masha-ecraft]

Do you need one line for each country and one line showing global average?

In this case you should have 2 dimensions: Period and Country, and your expressions should be like that:

Global average: avg({<Country>} Mark)

Average by country: avg(Mark)

[#10]

It overlaps lines.