I wanna show in a barchart avg of brokerages as bars and ad a line of the avg bars .How can i do that ?
Hello @agni_04, I will probably need a little more information about the visual you are trying to create to help you more, but it sounds like you want to use a Cluster Bar Combo Chart which I will link documentation to here.
You can place your brokerages field in the “Bars” field well and aggregate it for average and then what you could do is create a calculated field averaging your brokerages field over the x-axis value you are aggregating and enter that into the Lines field well. An example of that avg function would look like this:
avgOver({brokerages}, [{Date}], PRE_AGG)
Let me know if that helps!
1 Like
@DylanM I have a calculated field thats calculates the total sales of a agent is volume
then i have to plot all the agents and their volume in bars and a line showing avg and then
i have to plot brokerage wise avg line for agents in market
and branch wise avg line in market in the same visual
brokerage → branch → agent → volume sales
Hello @agni_04, I believe I know what you are looking for. You can add calculated reference lines into your visual. What you should to is create a calculated field for every average you want to show. You can utilize the avgOver functionality to average your sales by branch and by brokerage. It would look like this:
avgOver({sales}, [{brokerage}], PRE_AGG)
Then you can utilize the calculated line instead of constant line from the dropdown and link it to the field you created. I will attach an image below to show you how that would look.
