Create a bar chart for each headline indicator in Airtable
Kate Ruff
34 steps
2 minutes
Airtable
1
Click "Add group"
2
Click "IndicatorReport"
3
Click "Add chart"
4
Click "Bar chart"
5
Click Filter By
6
Add condition
7
Click "Headline Indicators" for the Where field
8
Click "is exactly..." for the rule field
9
Select a headline indicator
10
Click this icon.
11
Click here.
12
Click "endedAtTime"
13
Click this icon.
14
Click "Year"
15
Click this icon.
16
Click "1 field"
17
Click here.
18
Click this icon.
19
Click this icon.
20
Click "value"
21
Click this icon.
22
Click "Sum"
23
Click here.
24
Toggle orientation (optional)
25
Update the title field with the name of the headline indicator
26
Double-click the "Title" field.
27
Update the default section title from Indicator Report to Headline Indicators
28
Click this button.
29
Repeat for all additional Headline Indicators by duplicating the first chart
30
Click "Duplicate"
31
All you need to do is change the condition
32
Select the next Headline Indicator
33
Double-check that you don't have two headline indicators in the condition.
34
Repeat for each headline indicator. Don't forget to update the Title of each chart like I did in this Scribe!
Create a bar chart for each headline indicator in Airtable
Kate Ruff
34 steps
2 minutes
Airtable
1
Click "Add group"
2
Click "IndicatorReport"
3
Click "Add chart"
4
Click "Bar chart"
5
Click Filter By
6
Add condition
7
Click "Headline Indicators" for the Where field
8
Click "is exactly..." for the rule field
9
Select a headline indicator
10
Click this icon.
11
Click here.
12
Click "endedAtTime"
13
Click this icon.
14
Click "Year"
15
Click this icon.
16
Click "1 field"
17
Click here.
18
Click this icon.
19
Click this icon.
20
Click "value"
21
Click this icon.
22
Click "Sum"
23
Click here.
24
Toggle orientation (optional)
25
Update the title field with the name of the headline indicator
26
Double-click the "Title" field.
27
Update the default section title from Indicator Report to Headline Indicators
28
Click this button.
29
Repeat for all additional Headline Indicators by duplicating the first chart
30
Click "Duplicate"
31
All you need to do is change the condition
32
Select the next Headline Indicator
33
Double-check that you don't have two headline indicators in the condition.
34
Repeat for each headline indicator. Don't forget to update the Title of each chart like I did in this Scribe!
