Help

Re: Bar chart with field as bars

Solved
Jump to Solution
934 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Veronique_Blais
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I want to do a bar chart for every record using the three columns Ventes.
For example, bar 1: Ventes 2019, bar 2: Ventes 2020, bar 3: Ventes 2021
Is it possible?

I am joining an example for 1 record, I have 150 records in that view.

Capture d’écran, le 2022-04-01 à 19.23.24

Thank you

1 Solution

Accepted Solutions

hi @Veronique_Blais1,
recently I had a client with a similar problem. The approach I used was creating an interface with several bar charts, each containing the information for only one record (you can achieve this by filtering the records in the bar charts). This is a great option as it allows you to view all the graphs’ information at a glance but it does require a bit of manual work, as you need to create a separate graph for each record (you can of course duplicate the graphs and modify only the title and filter option to go faster).

From looking at your test record, this should not be a big problem as it looks like it refers to categories of products (which I guess would not be increased/decreased frequently)

Hope this helps!

Website: alessiomonino.com
Calendly: Calendly - Alessio Monino
Email: alessio.monino@gmail.com

See Solution in Thread

2 Replies 2

hi @Veronique_Blais1,
recently I had a client with a similar problem. The approach I used was creating an interface with several bar charts, each containing the information for only one record (you can achieve this by filtering the records in the bar charts). This is a great option as it allows you to view all the graphs’ information at a glance but it does require a bit of manual work, as you need to create a separate graph for each record (you can of course duplicate the graphs and modify only the title and filter option to go faster).

From looking at your test record, this should not be a big problem as it looks like it refers to categories of products (which I guess would not be increased/decreased frequently)

Hope this helps!

Website: alessiomonino.com
Calendly: Calendly - Alessio Monino
Email: alessio.monino@gmail.com

Andy_Cloke
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey, there is no way to do this with the Chart extension and Vega-Lite requires you to write JSON. But it's easy to do with our new extension, Charts & Reports - you can add multiple bars for each x-axis value and customize the color of each.

Screenshot 2022-12-05 at 12.01.12.png