Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon ... I have three variables. Gas station, Fuel liter value and fueled car. I wanted to build a scatter plot where the size is the post and the measures would be the average liter per post and the amount of supply per post. I was able to make the graph. But I wanted to draw a Y-axis reference line that would be the average of the average fuel value per station. Tried as follows:
avg (aggr (avg (liter), Gas station)) ...
The problem is, it wasn't. Does anyone have an idea how to draw this line that represents the overall average of the average fuel value?
aggr (avg (liter), Gas station)
it will bring avg per each station
if you wish to show one value .use referenceline..under addons
aggr (avg (liter), Gas station)
it will bring avg per each station
if you wish to show one value .use referenceline..under addons
I had tried like that, but I was making a mistake. Then it was. I do not know what happened. Thanks.