LinkedIn
Twitter
Is there a way to dynamically change the drill field set attached to a simple count measure based on the dimension it’s being grouped by? In the below table, I’d like to be able to customize the set of drill fields attached to each distinct status to render a completely different table for each. I’ve noticed that I could use liquid parameters to create a list of different drill fields that the user could then choose from, but my primary use case for this functionality is for a situation where the distinct values the corresponding dimension could take on 50+ distinct values, making a list cumbersome.
Alternatively, I can create a distinct measure and a distinct drill field set per potential dimension value (e.g. count_missing, missing_drills, count_review, review_drills...) but then I lose the ability to sort because each measure is a distinct series in my final visualization. Is there a way to sort across measures automatically? Re-ordering the columns by hand wouldn’t be viable because again, the dimension can take on many many distinct values.
