I have a measure called `timeSpent` which is time a user spent in seconds on a page.
I have attribute called domain which is the site the user visited, and I have the date.
I want to create a stacked bar chart showing the sum of timeSpent for each domain on each day. As there are too many domains I try to filter the top 10. However, that returns the top 10 overall, and I would like to show the top 10 sites per each of the days.
I went over the maql courses, and tried many different things, and I am struggling. I think that row_number could somehow help here, or at least that’s how I would have solved it in sql, but I am not sure how to use it here.
Â
Â
Best answer by Joseph Heun
View original