Dynamic filter to find maximum value within a CASE statement
I'm having an issue with trying to generate a dynamic comparison that can be filtered. What I want to do is to have a series of multiple updates to the dataset where I can pick two dates when updates occured and then see the difference between them (largest gains or losses). Each update has a unique integer identifier in a seperate column in the dataset.
I was thinking of using a beastmode like the following:
SUM(CASE WHEN `Update Number` = ceiling(`Update Number`) THEN `Revenue` ELSE 0 END)
However both the ceiling and max functions are resolving for individual rows and not for the overall dataset.
Due to the need to filter the data and the high number of updates, solving with SQL in the dataset is also not an option.
Any thoughts or suggestions?