I want to create a bar chart with the below requirement.
Available table name: “Fruit_Sales”
Available Columns in the table:
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.
Hey
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
