How can i create multi-measure bar chart?

Please find the below requirement

I need 2 bars on the X-axis without drill and present “footfall”.
Example i want to compare Product Type = PET_FOOD against all browse node for this. Browse node are Pet Supplies, Cat food, Dog food

The dark purple color is Product Type and light color is browse node.

1st 2 pillars are the comparison between PET_FOOD v/s Pet Supplies
2nd 2 pillars are the comparison between PET_FOOD v/s Cat food
3rd 3 pillars are the comparison between PET_FOOD v/s Dog food

Attaching data for reference

Hi @manaverm ,

Will you be able to create a sample analysis in Arena and share for the brainstorming here?

I am confused with product_type and browse_node fields. Do you want to show a kind of waterfall chart where the product_type bar shows the summation of the footfall for all browse nodes followed by footfall for each browse node?

Thanks,
Prantika

I want to show in the vertical bar chart as comparison. For more details you can refer below image

The value for Pet food is fixed = 75,184,573
So dark purple part in the graph will be fixed with 75,184,573.

The light purple contains example Backyard Birding & Wildlife (browse node name) = 6,762
So light purple part in the graph is 6,762.

Next part

The value for Pet food is fixed = 75,184,573
So dark purple part in the graph will be fixed with 75,184,573.

The light purple contains example Automotive (browse node name) = 882
So light purple part in the graph is 882.

To add a bar that shows total, there is not direct way to put a visual. This may require modification in the data end. Append a set of records to the existing dataset that calculates total at product type level under the same field search to click(shoppi…). You may need to be mindful of other dimension while appending, to avoid duplicate aggregation.

1 Like

Hi @manaverm,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll go ahead and close this topic.

Thank you!

Hi @manaverm,
Since we have not heard back from you, I’ll go ahead and mark the solution. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!