How can I get a chart per single industry

1

Hi all :wave: I want to use a chart, having 1-x categories (in our case industries).
A company may have more than one industry (used as a lookup).

Now: how can I get a chart per single industry, even a company may have more than one?
Right now it shows me each combination of industry as a value

Bildschirmfoto 2020-03-13 um 13.38.09
Bildschirmfoto 2020-03-13 um 13.38.091672×918 42.3 KB

2

Dear @Thomas_Schulz,

Formulas is not my strongest point, but did you check out First()

3

If you can share this doc here, or create a sample doc to share here, that will help us see how the data is set up.

4

Thanks @Ben_Lee here we go https://coda.io/d/bottish-Startups_dm0XuzO-mFU

5

Thanks @Jean_Pierre_Traets I am not sure if this helps, but just shared the doc here :pray:

6

Can you say more about what exactly you need to see in the chart? In particular, what value you need to see on the x-axis and what value you need to see on the y-axis.

If it’s just a count of the companies in each industry, you’re Industry table has that info and can be used in a chart, but it sounds like you’re looking for more of a breakdown.

7

Dear @Ben_Lee really sorry for late reply, you are right I would like to get values for each item (where they can be more than one for a company). e.g. how many companies, founded in year x are in the sector y