The average on chart

[brunolelli87]

Hello guys, 

How can I add a new line on my chart, to show the average prices of a group belonging to the selected company?

I have a list where the user can select a Company.
But each company belongs to a specific group, so I would like to show on a chart the comparison between the company's price and its group.

How can I do it?
Thanks

[lironbaram · Accepted solution]

hi 

you can achieve this with something like this ,

avg({<Company,Group=p(Group)>}price)

[brunolelli87]

Thank you so much!

It's exactly what I'm looking for...