A custom column after an aggregation prevents setting a filter at the dashboard level

[lenni]

The use case is specially relevant for all the "Non summative values" like efficiency calculation etc. Especially when the basis are time series data.

Git hub issue:

Custom Column after aggregation causes dashboard filtering to be very limited

was dealing with this and closed quite some time ago. But did obviously not solve it.

Reconstruction with the sample data:

--> first question with simple aggregation by date

--> as a second chart (I placed on the right - basis is the previous question) add a custom column after aggregation (as described, required for all non summative stuff like efficiency etc.)

--> Result on the dashboard looks like this - but only the left chart (without the custom column) can be linked to the time grouping filter

trying to link gives the Metabase message: "This card doesn't have any filds or parameters that can be mapped to this ..."

[lenni]

Now even found a work around

• you first link the time grouping Filter
• 2nd you can implement the calculation after the aggregation

Then everything works as expected - The time grouping filter works - but if you modify the filter, he claims on the question with the calculation "Unknown field"