Need help On creating the Bar Chart

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 ?


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.

FROM table
WHERE {{filter}})

Hello @flamber,

Thanks for the reply.