About MarcoSol

Looker User Group - Singapore

Hi there, In Singapore we started a community User Group. Is it possible to have our next event also featured on the events page? https://www.meetup.com/singapore-looker-user-group/Thanks

MarcoSol · 05-12-2022

Hi y’all,We’ve been Looker Partners since 2019, and we use our partner instance for internal training and demo’s to customers. Now a few months back the snowlooker connection which originally pointed at snowflake, got stopped. Is there a BQ alternati...

MarcoSol

I think this might be the old Snowflake connection with "The Look". I'm unsure if the samples are pre-installed for partners and customers alike. But as a Looker delivery partner we used to have this Example Ecommerce reports with a Snowflake connect...

MarcoSol

So I know on the explore Assistant the guys behind spectacles are holding webinar via LinkedIn tomorrow : https://www.linkedin.com/events/7189561968339398656/about/ . As far as, when the above tools would come plug-and-play natively to looker I have ...

MarcoSol

Not the prettiest solution but you can add a custom metric with count_distinct(vehicle_number) and set the running calculation as running sum. In the image below you can see distinct count next to the new custom field. If you're working with a larger...

MarcoSol

Hi Ajay, The out of the box system activities reports can be a bit limiting. You can build reports specific to your needs. The Event documentation also does not have all fields documented. But there is a lot of information under the hood. Try to play...

MarcoSol

Not sure how large your data is. It might affect what's the better solution. If the data is small enough you can try to go for a table chart. Select the date as your dimension with the date type. And the Vehicle number as the Metric. For the Metric t...

My Stats

Yugali's Bio

Badges MarcoSol Earned

Recent Activity

Looker User Group - Singapore

How to update Partner Instance Data Connection

Re: Where can i get LookML code for sample project that is pre loaded with Looker

Re: [APRIL 2024] Looker Customer Newsletter - The latest updates on Looker and more!

Re: I need a help in finding total unique daily vehicles.

Re: Audit logs for Looker core (private IP) admin activities.

Re: I need a help in finding total unique daily vehicles.