Chart Blocks somehow baffle me. I have a table with a month per year (so 2018 - 04 april) for instance as records and per record I have stuff like FB total likes, newsletter total size, IG total size. I would like to have 1 block that has all 3 together as lines, but I can’t seem to figure out how.
Am I doing it wrong or is it not possible with the table I made?
Airtable really needs a better graphs generator. It’s totally counter intuitive.
I have a table that lists different projects as records, and then time used on particular tasks (a different task per column) to complete said project. It would be completely counter intuitive to put each task as a record and different projects in the the columns, particularly since i like to see total time used by grouping projects by the same client.
The lack of this prevents me from doing a lot of simple things like plotting target vs actual on one line chart. This is the most basic feature a charting tool can do. Strange that it is absent.
Why on EARTH?! would it not just plot the Column on a line Graph/Chart like all other programs? It makes no sense to group data horizontally. My two cents after spending 30mins trying to work out how to do the same thing, pre google search.
I agree with the frustration here.
Having to set up data in this way means that you can’t use it with data gathered by forms unless you want users to have to complete multiple forms for one set of data. In the example above, if the data were submitted via a form, the form completer would have to complete a form for FB, and then another form for IG, rather than just submitting both pieces of data through one form.
I wish that Airtable would improve the charting tool as this is a major drawback.
Yikes, this has created a major usability problem for me: I’m building a database for a client who needs to track multiple metrics over time. If they need to make an individual record for each instance during the treatment session, they’re quickly going to max out the allowed # of records. Has anybody figured out a workaround for this?