7 Replies Latest reply: Jun 22, 2012 12:47 PM by kranti banala RSS

    Help with combo chart

      Hi All,


      I am trying to create a combo chart similar to the attached file.


      I have my data something like .   country/ Month / year/ passed/failed/total.


      I am trying to create a combo graph . where I  display total as bars and  pass rate as line [ BY COUNTRY].


      I tried to achieve the lines and bars by country , by month using aggr functions as below, but this   doesnt work. Any pointers on how I can get this done.


      My dimensions are:  YEAR / MONTH

      Expressions: sum(aggr(sum(total),country))   -- for  total by country

                           sum(aggr(sum(passed)/sum(total),country)) -- pass rate by country


      I am trying to achieve something like below.