Yes that query works but that's not what i was looking for .. may be my requirement is not clear The average should be in such a way that (row wise) like in the month of match 15 percentage of event is series 1 and 35 percentage is series 2 and 50 percentage is series 3 . series is nothing but events like offer created or something. i can show example .. Find average to the total events in that month to each event(occurrence percentage of each events compare to total events for each month) date_month series1 series2 series3 March 15% 35% 50% February 16% 36% 48% base query | chart count over date_month by seriesName this is the query that we use now . it gives count in expected way ..
... View more