Dataflow or View Query to run AFTER user filter pages

bradyprice19

Sometimes it can be really difficult to build an end dataset that will be able to calculate the metrics that my users care about on the fly in a beastmode. For example:

This contains 3 different fixed functions so that I can show a certain metric dynamically to the user. Because of the high computation (mixed with a big dataset powering it), I get the following error:

I know that the way around this is that we can create a dynamic view of our main dataset based on whatever the user filters instead of housing it in a beastmode. Or even having it trigger an ETL. I know that a lot of ETL's take time to process, but there's got to be someway we can fix problems like this.