About lizzy1

lizzy1 · 04-25-2022

We are looking for a BI Data Analyst to join our Analytics team at Headset! Details about the role are below. If interested please apply here: https://www.linkedin.com/jobs/view/3039320622About HeadsetFounded in 2015, Headset is turning retail-derive...

lizzy1 · 06-02-2021

Hi! We’re looking for an analytics engineer to join our growing team. We are based in Seattle but the role is remote (if you prefer). We’re looking for just a few years of experience and someone that would be okay being customer facing (debugging/edu...

lizzy1 · 08-30-2021

@psidhu I would create two separate dimensions - one for year and one for week number and put both filters on bc I think the experience for the end user will be cleaner. However you could concatenate week and year into a single dimension if you wante...

lizzy1 · 08-30-2021

I think the easiest way (as long as the groups are stagnant) is a case statement that works like this:case when employee_size ilike ‘%-%’ then employee_size when try_to_decimal(employee_size) = 1 then ‘1’ when try_to_decimal(employee_size) between 2 ...

lizzy1 · 10-20-2020

If you aren’t tied to circles you could do a stacked bar chart. Not sure what your data looks like underneath but I would probably do something like this: Make a derived table that is the user attributes I want. In this case something like: select us...

lizzy1 · 06-10-2020

lizzy1 · 06-09-2020

You can do it in the vega visualization by selecting X as one of measures and Y as the other measure (under 1. Axes). Then under (2. Mark) choose Mark Type as Circle and Color as your Dimension. It’s not super pretty but it does what you’re asking.

My Stats

lizzy1's Bio

Badges lizzy1 Earned

Recent Activity

Headset (Cannabis Retail Analytics) is hiring a Looker Developer

Headset (Cannabis Retail Analytics) is Looking for an Analytics Engineer

Re: [Solved] Week of year over Week of year comparison

Re: grouping number and string data types into one dimension

Re: Looking for a Venn-Diagram

Re: creating a dimension based on measures

Re: Scatter plots with metrics only on X & Y axes