This content has been marked as final. Show 3 replies
Thanks for your response, but I'm not trying to pass the "all values" through a presentation variable. Rather I'm attempting to create a CUSTOM naming for "(ALL COLUMN VALUES)"
Example, I have a dimension that is a list of products with 20K+ distinct values. On the prompt that filters this dimension i want the "All Column Values" selection to display as "All Products".
The article i linked in my original post shows how to do this using a custom group, but the author selects the 50 members manually. This works if your dimension is something like states, but not for my "products" dimension that has 20k+ members.
Furthermore it would be useful to have the custom group only made up of SELECT members that i chose with a SQL statement, such as all members with sales > 100k for the last 6 months.
Yes giving the "All column values" a custom name is splitting hairs, but the summation of small tweaks like this is what sets apart "intuitive" reports from "bulky" reports.