I am trying to create a report by aggregating to Customer Group level.
Issue:
If I keep Collector Id as dimension (where it should be), Unable to aggregate.
If I keep as Measure for Aggregation, in Collect_id Filter, shows empty value.
Solution I found:
As I came to know, I have to keep Collector_Id as Measure as well as Dimension. Use Measure for Aggregation and use Dimension for Filter to make this work.
I don’t like to keep duplicate LookML code and hide in explore. Otherwise users will get confused.
Please suggest a solution.
Hi yoghee_yoga,
When you say:
If I keep Collector Id as dimension (where it should be), Unable to aggregate.
In your real data, are there multiple “Collector ID” values for the same “Customer Group” values? In that case the behavior is expected, since Looker shows all the combinations of (Collector ID, Customer Group) values when they are selected as a dimension. If you drill on a particular combination, the filters should be set correctly for both dimensions. If you want to see all “Collector ID” values on one line, you could use list measure.
If not, meaning there is a one-to-one correspondence between “Collector ID” and “Customer Group”, then why do you need to filter on both of them? Apologies if I am misunderstanding your setup.
Note there is also different behavior when drilling from a dimension versus a measure. You may want to try setting up a drill on the “Sales Amount” instead.
Please feel free to show us more examples, including the dimension & measure definitions where you have defined the drill fields.
