Report for creating stacked bar chart/graph with Column reference that is dynamic?

SSTB

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

Genevieve P.

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