how to provide different category expressionsfor the stacked bar chart

[kcsekhar25]

Hi all,

 

i have a  very peculiar requirement i think.

 

i have data like below from a query

 

buildname    severity       no of defects

 

R1                     sev1              5

R1                      sev2               6  

R2                      sev3              8

R2                       sev4             7

R3                      sev1               4

R3                       sev2               2

 

 

 

now i want to display category expression as below

 

 

                                   |

     y-axis                    |

      Value  axis          |

                                    |

                                    |

                                    | -------------------------------------------------

                                        sev1    sev2 |    sev3   sev4    |     sev1     sev2

                                                    R1     |          R2             |              R3

                                                      X-axis  Category expression

 

 

how to represent the sub categorys under main categort R1 ,R2,R3 in the Category expression.

 

 

 

i am breaking my head on this but i am not even getting closer to it.

 

 

anybody have any clue on this.

 

please reply me urgent,

 

sorry for using the word urgent but i need to use

 

Thanks alot

waiting for ur reply

 

[kcsekhar25]

Hi,

i got rid of this problem by suing Jasper Server Adhoc Editor and was able to get this grouping.

 

Thanks