Question

Bar Chart Visualization

  • 10 December 2020
  • 3 replies
  • 102 views

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. 

 

Can someone help me on this please.


3 replies

Userlevel 2
Badge

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-Tooltip

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:

 


Kind Regards,

Daniel

Thanks for the help

Reply