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.
Try WHERE (X.IsVoided is false OR X.IsVoided is null) AND (Y.IsVoided is
false OR Y.IsVoided is null) The problem is that you’re specifying that
both tables need to be false, but if one of them is null, then no record
will be returned.
Hi @Karan_Veer_Sing You’re selecting user_id in the daily_use table as
you want to know if a user_id was active on a certain date. Without
selecting user_id you’d just end up with a list of dates, not knowing if
a certain user_id was active on that d...
It’s be helpful to know a bit more context around the problem e.g. what
you’ve defined as the join ON and WHERE clauses. To display 0 instead of
null, try SELECT COALESCE(value,0) I imagine there’s something in your
WHERE clause that’s preventing res...
Hi @Karan_Veer_Sing, If you need a quick and easy but less accurate
solution, you can do so with 3 table calculations: 7DAU
mean(offset_list(${page_views.user_count},7,7)) 30DAU
mean(offset_list(${page_views.user_count},30,30)) Ratio ${7dau}/${30dau}...