I am trying to add fields (more than one) dynamically from a filter (which has a list of fields defined as a measure/dimension in the LookML) to an existing dashboard visual (table). So when I select a field or more than one field from the filter the...

Hi! I recently implemented Pop Analysis Method 4 (Compare Multiple Templated Periods) in an explore. It works fine except for the Period dimension. When I select the Number of Periods parameter as 2 I should be getting just This Year and Last Year as...

Hi All, I am trying to create a custom measure to get the last 6 completed months (04/2020-09/2020) for the current year and another custom measure to get the 6 months for the same period (04/2019-09/2019) for the previous year to compare against eac...

I am trying to create a Look to show the number of first time users by month based on their first payment_date (min) on a monthly basis. For example if I have user_id 123456 and he/she has made 3 payments on 02/07/2020, 02/28/2020 and 03/02/2020, I w...

I am trying to create a table calculation/custom field by summing up a yes/no dimension but I am not getting the desired result in my data. Below is my table calculation, Registered_Users (Custom Field): sum(if(${users.is_registered},1,0)) It gives t...