Help
Other questions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Displaying Null Values in Pivot Table Block

Hello, I’m using the Pivot Table block and am looking for a way to display null results. In other words, I want the table to display “0” for any instance when a combination of items is null. I tried to post an image here to show an example but got an...

Stacking bar chart?

Hi folks, I’m trying to figure out how to visualize some data. Would love some help on this I pull in data from a typeform survey into my table. Data is all likert-style rating on a 1-5 scale. I want to show how many people assign each respective sco...

Airtable Universe

To capture structured data from Airtable Universe, you can use the following clip action recipe: { "schemaVersion": 3, "fieldMappings": [ { "fieldName": "Name", "fieldType": "singleLineText", "defau...

Counting items within a multiple select field

Hi there, I have a People table with a single select Age category (e.g., Boomer). Each person has chosen multiple Trends, which is a multiple select category linked to another table. In the Trends table, there is a column with each Person listed. I c...

Chris by 5 - Automation Enthusiast
  • 1999 Views
  • 4 replies
  • 1 kudos

TEXT in a pivot table

Presently I use Excel to create a horizontal table from a vertical source. That is Bill Alpha Bill Beta Bill Omega Fred Beta Fred Tau BECOMES Bill Alpha Beta Omega Fred Beta ...

WIN_ACRC by 6 - Interface Innovator
  • 770 Views
  • 0 replies
  • 0 kudos

How do I filter to a single row of a grouped record?

Hello Airtable Community, I’m building a database where I’m continually ranking content based on a given criteria. In my database there are 30 publishers with each publisher having many blog posts assigned to them. I want to know, of the posts publis...

Jared by 4 - Data Explorer
  • 1706 Views
  • 3 replies
  • 3 kudos

Comparing dates within field for max date

Hi all, I am a newbie to Airtable and need help selecting which date is the farthest into the future from within a field in my projects table. I have a lookup field in my projects table referencing my task end dates from my tasks table. I want to h...

Recolor lines in chart block

Hi there, I am trying to synch the coloring across different chart blocks (i.e. that the performance of a specific user is colored the same in a bar chart, in a line chart etc). I havent found a way to decide which color a specific line has in a line...

Marc_Maurer by 5 - Automation Enthusiast
  • 1483 Views
  • 2 replies
  • 2 kudos

Sum in Pivot Table is incorrect

Hello! It seems that the sum line of many of my pivot tables are incorrect. I can’t seem to track back the reason why. Any help would be much appreciated! See screen shots below.

Screen Shot 2019-06-11 at 10.03.57 AM.png Screen Shot 2019-06-11 at 10.03.10 AM.png

'Days Since' Chart with a unique issue

Hello there, Thanks to this community I’m well on my way to creating a “days since last contacted” graph, but I’m running into an issue. I have a rollup column that uses the MAX() function, and then a formula column that runs this calculation: DATET...

Airtable -> Link Analysis Software

I have bases with complex relationship data that I need to visualize and the organization chart block is too basic. Think social media link analysis. Does anyone else have a good pipeline setup to export Airtable data to link analysis software? We ha...

John_S by 5 - Automation Enthusiast
  • 1031 Views
  • 0 replies
  • 0 kudos

Unable to chart duration data

I can’t seem to chart any duration data. Is this a limitation or am I doing something wrong? Example of the same data I put into Google Sheets. https://imgur.com/veD97Z0

How can I create a histogram or something similar?

Hello, I am working on an inventory system for my plants. I have the following data for different sizes (1/8, 1/2, 3/4 or empty) and have a corresponding number of occurrences of those values. I am looking to make a pivot table or chart that displays...

Capture

Set Up for Multiple Organizations

Hello, I’m trying to figure out if Airtable will work for our needs, but I feel like I’m missing something. We have 25+ organizations that need to add/update member data. Each organization will have two Admins who can access their own organization’s ...

Logging a metric over time (Record count by category)

We use Airtable to track client projects through multiple phases of work. It’s important for us to know how many projects are in a given phase and to track this distribution over time. I easily created a pivot table block to display how many projects...

Matt_Caruso by 6 - Interface Innovator
  • 3574 Views
  • 5 replies
  • 4 kudos