I have a query that returns:
DATE TYPE COUNT AMOUNT TOTAL_COUNT TOTAL_AMOUNT
-----------------------------------------------------------------
05/09/2006 rebill 101 1802.95 119 2247.05
05/09/2006 upgrade 1 74.95 119 2247.05
05/09/2006 sale 17 369.15 119 2247.05
05/08/2006 sale 23 673.85 24 693.8
05/08/2006 rebill 1 19.95 24 693.8
05/07/2006 rebill 6 116.7 11 246.45
05/07/2006 sale 5 129.75 11 246.45
where TOTAL_COUNT and TOTAL_AMOUNT are sum of COUNT and MOUNT for the day.
I want to make a graph where x-axis will be DATE
and each bar will be divided into 3 parts (rebill, upgrade, sale).
y-axis will be TOTAL_COUNT or TOTAL_AMOUNT (I can make 2 separate graphs).
Something like this:
<pre>
each bar represents TOTAL_AMOUNT for the day.
+----------+
| rebill |
| |
+----------+
| upgrade | +-----------+
+----------+ | |
| | | rebill |
| | | |
| | | |
| sale | +-----------+
| | | |
| | | upgrade |
+----------+----+-----------+-----------
05/07/2006 05/08/2006
</pre>
I think i need to use stackedBar3DChart for that..
Could you give me a portion of xml that can generate graph
looks like above?
(you can consider DATE, TYPE, COUNT, AMOUNT, TOTAL_COUNT, TOTAL_AMOUNT
are fields. so that you can put $F{DATE}, $F{TYPE}...etc)
Thank you.
Samuel Lee.
Title: stackedBar3DChart question.