I’m trying to create a report where users can view the Revenue by month OR the Clicks by month. I think Dynamic Measure Filters would be the way to go. I have this in my LookML but it’s not working. What am I doing wrong? measure: revenue { label: "R...

I have an END Date Field in my View that I want to include into a measure drill field. The End date is defined as: dimension_group: sf_bill_period_end_date { label: "Billing Period End" type: time timeframes: [ date, week, month, quarter, year ] sql:...

How do I remove the last 3 characters from a string in LookML? For example, I have “ownername2022:03:29”and I only want ““ownername2022:03”

I have a Date field I would really like to convert into a STRING so I’m able to use it in a CONCAT field. How do I do this ?The fields I’m trying to CONCAT currently are listed:sf.owner.nametype: stringsf.subjecttype: stringsf.event.datetype: date