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.
Hello,I have a table with the dates customers made purchases.Please I
would like to calculate the number of days between the first and second
day of purchase, between the second and third day of purchase, and
between the third and last day of a custo...
HelloPlease, from a custom filter, the user chooses a date interval I
want to compare the number of this week to the number of the same week
last yearThanks
Hello, I would like to calculate the period over period with weekday
number by letting the user choose the date range he wants to compare and
the comparaison period.Thanks
@Dawid please can i have a code lookml to Comparing a Previous Week to
that Same Week Last Year from this example.Thanksdimension:
period_comparison { case: { when: { sql: ${date} >= DATE_TRUNC('month',
GETDATE()) AND ${date} < DATE_TRUNC('day', GETD...
@Dawid Thanksif i have 2 views with each of the views has a date field
is it possible on looker to filter from a single date filter from one
view the measurements from the other view