I have a table with several metrics, let's call them metric A, metric B, metric C, etc, each of them has several hard ranges, Week 1, Week 2, Week 3, etc, and a GLOBAL (summed) aggregate of each individually. Is there a way to have a control/dropdown thing that allows me to say "I want to see Week 1" and all of them show me only the Week 1, or select all of them and allows me to see the GLOBAL one?
I can pull the GLOBAL one with a Calculated field, no issue, the big trouble I'm having is how to let looker know which data set I want to show with the dropdown.
I'm going crazy with this, can't find anything that resembles it, help would be heavily appreciated.
LinkedIn
Twitter
