About hrucchetto

hrucchetto · 10-13-2022

Hello Folks,I wanted to create several measures (over 10) and the only difference between them is only one number. I mean, i need to create revenue day 0, revenue day 1 and so on. So, i was wondering if there is a way to perform this in a DRY way, ma...

hrucchetto · 12-16-2021

@here, Hi all!!!I’m using the following sql script to obtain the top N from different categorical variables.I need when I change the period of time, it changes the result I get.So, I add in WHERE clause the condition for the date column.But when I us...

hrucchetto · 10-03-2021

hrucchetto · 07-16-2021

I want to show the MoM and YoY for 2021 (vs 2020) in a graph. But when I filter the dataset from 2021-01 to now. The graph only shows the MoM from feb-21. It doesn’t show the jan-21 MoM and the YoY for all the months. I think that it happens because ...

hrucchetto · 07-12-2021

Hi,I have a bar chart grouped by a categorical variable.Im trying to add the MoM variation as a value in the tooltip, so I don’t have to create a new plot to show it.Someone can help me with this?Thanks.

hrucchetto · 12-16-2021

The LookML code is the one I copied in the first post. sql: SELECT field, CASE WHEN rank > {% parameter view1.param_rank_max %} THEN 'Other' ELSE field END AS topn FROM ( SELECT field, cost, dense_rank() over(ORDER BY cost DESC) as rank FROM ( SELECT...

hrucchetto · 12-16-2021

This is the result I got:SELECT team AS field,sum(cost) as costFROM tableWHERE (team = ‘Untagged’) AND1=1 -- no filter on ‘view1.cost_center’ AND1=1 -- no filter on ‘view1.application’ AND1=1 -- no filter on ‘view1.usage_raw’GROUP BY 1the query is no...

hrucchetto · 07-13-2021

Hi @Dawid,Yes, I tried to hide the the table calculation from the visualization and the value disappeared from the plot. I’m a Looker new user. These kinds of things in power bi are super easy to realice. So Is not it possible to do? 

hrucchetto · 06-25-2021

Hi @yadderace,This is the bug: Error running query: org.apache.spark.sql.AnalysisException: GROUP BY position 5 is not in select list (valid range is [1, 1]); line 6 pos 9.SELECT 5 AS cost_table_rank_limitFROM development.cost_table AS cost_tableGROU...

My Stats

Bertrand_MUNIER's Bio

Badges hrucchetto Earned

Recent Activity

Creating several measures with same LookML code

Issues using dates condition in WHERE clause

How unpivot a table in LookML?

Issues filtering a plot with table calculation

Show additional data in the tooltips of the visualization

Re: Issues using dates condition in WHERE clause

Re: Issues using dates condition in WHERE clause

Re: Show additional data in the tooltips of the visualization

Re: Top5