Bar Chart Visualization

ammu
Participant I

I want to create a bar chart with the below requirement.

Available table name:  “Fruit_Sales”

Available Columns in the table:

  • Fruit_name
  • Items_sold_Count
  • Profit

Requirement:

I want to create a bar chart for the top 10 fruits sold and the the profit for the top 10 fruits sold in the below format. Left is the graph for items_sold_count and right is the graph for profit. 

4595aa78-fb47-4a67-91ad-37fdf4229d93.png

Can someone help me on this please.

0 3 356
3 REPLIES 3

David_P1
Participant V

Hey @ammu

You can simply use the “column” visualization with your dimension being Fruit_name and your 2 measures being Items_sold_Count and Profit. You can then apply two y-axis for count and currency. IMO it would be a more intuitive visualization than the one posted. Not sure there is a plug-in in the marketplace that allows the side-to-side outcome you are looking for.

An alternative would be to create a visualization that focuses on a single measure e.g. Items_sold_Count and then leverage the tooltip to make the Profit data accessible (upon hovering over the columns). Here is an article that describes the process: https://help.looker.com/hc/en-us/articles/360023508894-Displaying-Values-From-Other-Fields-in-the-To...

Hello ammu,

One additional way to create your visualisation could be to put the data in a table with cell visualisations applied. To do this, select the dimension (Fruit Type) and two measures (Items Sold and Profit), and change the visualisation to a table. Then, under the edit -> series tab in the visualisation options, enable cell visualisations  and you will have a bar that is respective to the results of your measures. It could look something like this:

 

27d73171-6e39-4336-bba0-82566fb64240.png


Kind Regards,

Daniel

ammu
Participant I

Thanks for the help

Top Labels in this Space
Top Solution Authors