About cristian2

cristian2 · 08-31-2020

Hi all, I have this view which I need to filter: view: orders { derived_table: { explore_source: orders_exp { column: date {} column: OrderID {} column: Product {} filters: [v_orders.date: "before this month"] } } } I got another view with only one r...

cristian2 · 04-11-2020

Hi, I have a scheduled Look that is sent through email to users. It’s a normal list. One of the dimensions in the list has a link to a dashboard (clicking on the link opens a filtered dashboard with the value in the dimension). This works fine when e...

cristian2 · 04-06-2020

Hi all, I have a working dashboard with a filter based on a timestamp field. This works fine - there’re date and time components in the filter. When I change the dashboard to “dashboard-next” the time component disappears from the filter. What am I m...

cristian2 · 03-26-2020

Hi all, Sorry bad topic… I need to calculate a running total but need to reset the total on a condition. I have this table - Date is the only dimension - all the others are table calculations: Date, Registrations, Expected Registrations, Expected rea...

Last day of last month user filter · 03-03-2020

Hi All, How can I use the advanced filter to create a filter to query the last day of last month? Or, should this be done in a customer filter? I have a date field and would like to have a relative filter to always filter last day of last month. Any ...

cristian2 · 10-07-2020

Disable the cookie banner in looker admin until the bug is fixed.

cristian2 · 04-11-2020

ok I found it - I had to change to “advanced” in the new filter. But, still I cant change the minutes in the new one. This is the old filter style: And this is the new one:

cristian2 · 03-31-2020

xin: coalesce(if(${expected_reached} = 0, 0, sum(offset_list(${expected_reached}, 0-(row()-coalesce(max(offset_list(if(${expected_reached} = 0, row(), 0), 0-row(), row())), 0)-1), row()-coalesce(max(offset_list(if(${expected_reached} = 0, row(), 0), ...

cristian2 · 03-31-2020

OMG! I have to try this! Imagine a table function for this: running_total(value_column, column_1)

cristian2 · 03-27-2020

Thanks @Cyril_MTL_Analy I was hoping for a combination of table calculations…But will look into a sql solution… @izzymiller Any suggestions from you?

My Stats

Ashishkumar2's Bio

Badges cristian2 Earned

Recent Activity

Filter a derived table based on an explore

Adding link from dimension to scheduled Look sent through email

Time component on filter disappears when converting to dashboard-next

Running total with a condition or...?

Last day of last month user filter

Re: Cookie banner in the PDF

Re: Time component on filter disappears when converting to dashboard-next

Re: Running total with a condition or...?

Re: Running total with a condition or...?

Re: Running total with a condition or...?