Can users define group by clause in explore?
Hi, I want to create the following query in looker:SELECT _______, COUNT(*)FROM MEMBERGROUP BY _____In the cod...
Forum Posts
How to create flexible GROUP BY on LookML
This is the function generated in SQL, I want to include c.bkg_no, c.cntr_no, c.cntr_tpsz_cdm on GROUP BY belo...
Populate earliest date of status at item level in each row
Hi Guys,I am a beginner in Looker and trying to achieve below requirement.Data set : Item_id created_date stat...
How do I remove the GROUP BY clause for an explore/view with non-aggregate measures?
I have a pre-computed metric table that has a small set of dimensions and non-aggregate measures. How do I mod...
Group by
I am trying to create a scorecard which shows Store count if the profit > 80%.Can you please tell me how to wr...
Definitions of grouping functions using Group function
Does anyone know the exact definitions of these conditions using the “Group By” function on the front end of l...
How to create a group by measure using LookML?
Hey,I have 2 steps of a calculated field -First step, I created a derived table that calculate ccy_usd_amt gro...