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 merged two queries with date, ID1and ID2. Now, I hide the ID1 and ID2 from visualization and I want to aggregate the result only by date, is it possible?
You need to use derived table for that. Merge queries are not for creating a base where you can change the granularity. If you joined it by ID then the granularity will always be at that level. You probably could do some hacky table calculations but by design this should be merged together earlier, on an explore level.
LinkedIn
Twitter
