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.
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...
Maybe the pivot is giving trouble.Try creating a filtered measure on the
count distinct cases directly. Pass filter condition to identify
positive cases from them. Then create another % measure from this new
field (the option would be % of column). T...
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.
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...