I want to use Stacked Bar chart to show the number of users in top 10 cities out of 50 but couldn't find an option for it. Is there a way to make it happen without changing the DB?
Thanks.
I want to use Stacked Bar chart to show the number of users in top 10 cities out of 50 but couldn't find an option for it. Is there a way to make it happen without changing the DB?
Thanks.
Hi @Dan1
It's difficult to say with limited details, but perhaps something like this:
If you need to do more advanced calculations, then you might have to use CTE in SQL:
Redirecting…
This works! Thank you so much!!