Creating a counting dashboard in another table

Topic Labels: Formulas
592 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Good morning!!

Today I’m trying to build a dashboard for my hiring process (for multiple companies) and I’m facing a problem I’ve already had.

Currently candidates are in a table ‘Candidates’ with one column for name / companies / status… and hundreds of rows.

My ultimate goal would be to summarize all these infos in another one table e.g. Number of candidates in Specific positions per Specific companies.

Can’t get over it with the look into another record / rollup formulas and I was hoping you could help me!
My guess is that it would eventually look like this:
Capture d’écran 2021-04-08 à 10.34.44

Thank you very much in advance,

1 Reply 1

Hi @Gaultier_Brun - this can be done if you have one table for candidates and another for companies. If the candidates table has a linked field to the companies table, then you can use the companies table to form your dashboard. Conditional rollup fields (based on the candidate status) would allow you to create columns to show number of “status A”, number of “status B” and so on.