This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Which is why I would suggest using a regular expression in the LookML.To
help the community help you, please could you explain a little more
about what you’re trying to parse from the URL?Many thanks.
Hi tatuspark,It sounds like you’re trying to create a period comparison.
You can do this with the “Mathces (Advanced) filter in the Explore
window:last month, 13 months agoAlso, I’d suggest renaming your
dimension “vente” to “vente_id” and your dimen...
Hi,What part of the URL are you trying to extract?I’ve always found
regular expressions (in LookML) very helpful for things like this but if
you’re looking to do this in a table function, you’ll probably need to
use:replace(substring(${string},if(pos...
Hi Lorena, I think, in your visualisations, you can add %I%p to your
field to format it as olde-worlde time. Sadly, I don’t think Looker
currently has the functionality to create a named_timeframe, as is
possible with named_value_format which would b...
I think your best approach is to model your view as a derived table,
then add a column in your SQL query a bit like this: SELECT *,
COUNT(Field2) OVER (PARTITION BY Field1) AS Field2Count FROM Table1 Then
create your measure as type: max. Hope this h...