Report for creating stacked bar chart/graph with Column reference that is dynamic?
I am trying to create a report based on the RAID log where the stacked bar shows all items of a subject (example Absence) and on that stacked bar show items by type (Risk, Action, Issue etc).
I have upwards of 25 columns, so I want to have the column be referenced in the formula, without having to type in the Column name for each of the 25 rows. Is it possible to have the formula reference the column without having to use the words from the column name? I want something like the @row functionality but for the column.
My formula looks like this now, but I want to have the Absence piece be dynamic (and not hard coded) for 25 values.
=COUNTIFS({RAID Log | Type}, $Absence$1, {RAID Log | Functional Area}, Metric@row)
Am I going about this the right way
Answers
-
Hi @SSTB
If you don't have the $ absolute reference in front of the Column Name, then you can simply drag it to the right and it will auto-update the new name for each column.
From:
To:
The absolute reference in front of the row number should stay there so you can drag-fill down the same column and keep it on row 1. See: Create a Series of Numbers or Dates with Drag-Fill
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!