About adnanjmi

adnanjmi · 09-20-2022

I have connected GA4 block and setup the connection successfully , most of the dashboards are working fine except for few , where i am getting error as A LookML model issue prevented this query from running.Unknown view "shopping_list" referenced in ...

adnanjmi · 10-01-2022

You can achieve this by pivoting on x . Looker will do the rest for you 

adnanjmi · 09-24-2022

In SQL you can’t equate to null instead you should write as ${orders.need_by_date} is null

adnanjmi · 09-20-2022

Hi Dinesh ,you can accomplish this with the help of user attributes , Inn LookML you will have to set the default value based on the user attribute valuesee doc

adnanjmi · 07-30-2022

Hi Vince,Can you elaborate more and share the Lookml code for this dimension , you can try using value format

adnanjmi · 07-29-2022

Hi Fizza,If above solution aren’t working for you , you can create a derived table similar to this with dau as (select count(distinct userid) dau, Date(event_time) date_event from events where Date(event_time) > '2022-07-01' group by 2) SELECT date_e...

My Stats

Aimeemca's Bio

Badges adnanjmi Earned

Recent Activity

Google analytics GA4 Block LookML error

Re: How to make grouped column visualization out of simple select?

Re: Creating if statement to get the time in-between two dates, but if the need by date is NULL then I want to use The create date

Re: Filter default selection based on user

Re: Is there a way to remove the suffix in the table for duration dimensions?

Re: Rolling 30 day count distinct