Dynamic Column Possible?

Hi All,

I have this chart below and would like to use the date filters to get the number of customers impacted by outages only in 2022, for example:

  I'm using the code below to create a column - Y axis data (renamed in the charts as # Outages):

The Y axis is grouping all the customers together who have been impacted by outages 5 times for example and the X axis gives me a total count of the customers. Because the Y axis data comes from a column, it is fixed and does not adjust when filtering with a date column.

Is there a way I can change this so that the # Outages column is dynamic and correctly responds to date filtering?

Your help would be appreciated.