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

    Help with combo chart

    kranti banala

      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.