Just getting started with looker and building our first model. We have reference/dimension tables in our database that we need to join multiple times to the fact tables in lookml. We’re in healthcare, so one example is for physician details, where a hospital visit has several physicians - primary care, admitting, attending, consulting, surgeon, etc. We want the physician details to be grouped in the field picker depending on what the physician role was, but it seems we’re only able to give one group_label to the dimension fields in the looker view.
Is there a way to override the group_label based on the join? Do we need to create copies of the reference table view for each time it will be joined in the model?
Best answer by yale.madden-1631107790View original