Need help On creating the Bar Chart

#1

Hello ,
I need a help on creating a bar chart which shows percentage of data as per the applied filter for the month.
I got a scenario like first i need to fetch the monthwise activation data for the Financial year.
I got to filters to apply , based on the applied filter its percentage should get change for the month not for the Financial Year.

Basically i need to get percentage on Dynamic count(After applying the filter)/Static count

How can i achieve this ?

Thanks

#2

Hi @sushant.naik
Not sure I fully understand what you’re after, but it sounds like you would need to divide by a sub query, which is similar to the primary query, but without any filters.

SELECT (100 / NULLIF(COUNT(*),0) * (SELECT COUNT(*) FROM table)
FROM table
WHERE {{filter}})
#3

Hello @flamber,

Thanks for the reply.