pl_Luke Member

@jaeW_at_Onyx Following up with this, I went your suggested route and UNION'd the data onto itself to get my desired results. While not ideal because I wanted to run multiple different metrics off of the same dataset (which I guess I still could by constraining to only union A or B...), this still is a good work around…

Thank you for the suggestion @GrantSmith ! Unfortunately I dont think this accomplishes what I am after, while it is a step in the right direction. It seems segments allows to ignore specific filters like I am interested in, but it doesnt seem you can then use it in a beastmode. Since I only want the denominator in my…

The intent is to have it much more dynamic than listing it out manually in the calculation, however your idea inspired me a bit. Would I be able to reference a list disconnected from the dataset? Then I could use the disconnected list as my "filter", which wouldnt filter down the dataset (allowing me to get my desired…

Mark, thank you for the reply, however this does not address the issue I have. When creating simple sums for each column there is no issue as you say, however I want one of the columns to ignore a specific filter. In what you describe all columns would be filtered, and I do not end up with the example table that I describe…