Custom Block: Multiple Table Chart

[Russell_Bishop1]

Hi there,

I’m looking to work with a developer to create a custom block to the following specification:

Sketch

Multiple Table Charts — Artboard

Shared on Sketch by Russell Bishop

• Display a single bar chart with two tables as the source of the data
• Assume that both X Axis and Y Axis from different tables are the same data type
• Ground the bars by their origin table.
• Assume SUM as the aggregator of the data when grouped by an axis (to keep things simple)

You can read further information here:

Charts displaying data from multiple Tables Product Suggestions

I am often in a position where I would like to compare data from two tables. Say for example, one table was my Estimations table, where I have many entries where I forecasted the result of something. In a separate table, I have my Records, where I recorded the results of entries. If I wanted to map those those table together, there is no way to do so. The only solution is to merge those two tables into one single table. This would be fine if the data was used in exactly the same way (all of …

If you are confident you could build a charting solution like this - please reply here and we can discuss further over email.

[amanda_jones]

hello Russel,

i would like to help . please check PM for contact details,
Regards,
Amanda

[Russell_Bishop1]

Note for anyone responding:

Please only get in touch if you have proven React experience, and/or have already built a Custom Block for Airtable.

[Russell_Bishop1]

I’ve updated the original post with a prototype and short spec:

https://sketch.cloud/s/Kme8n/a/vGgrw3/play

• Display a single bar chart with two tables as the source of the data
• Assume that both X Axis and Y Axis from different tables are the same data type
• Ground the bars by their origin table.
• Assume SUM as the aggregator of the data when grouped by an axis (to keep things simple)

[Ivy_Lee]

Happy to help! I’ve built a custom block, happy to share it with you :slightly_smiling_face:

[Russell_Bishop1]

Great, please DM me Ivy