Hi,Try using table calculations for this use case. Create 1st calc to extract hours from your time field (use function extract_hours() ) and 2nd calc over the 1st to provide a range condition like ${hours}>7 AND ${hours}<9. The 2nd one will give a ye...

Hey,Try creating a custom measure for the user field. Select measure type as count distinct. This will ensure it counts users only once. There is an option below to add additional filter where you can provide the condition of is user=true.

Try function now()

Trying to understand here, so the CTE used to bring one line per product. But if you introduce the date column it opens up to multiple lines. ( i hope this is the issue)Are there timestamps with the date value, which is causing it to open up? else th...