Skip to Content
0
Former Member
Feb 24, 2009 at 02:54 PM

Struggling with BusinessGraphics

10 Views

I can create simple bar and pie charts, but there is a chart that I just can't seem to get rendered properly.

The data would look something like this:

Context
    |
    ---- Region
            |
            ---- Location
            |          |
            |           ---- Details
            |          |         |
            |          |         ---- Date
            |          |         |
            |          |         ---- Time
            |          |
            |          ---- Name
            |          |
            |          ---- Value
            | 
            ---- Name
            |
            ---- Value

So I have 1..n Regions, each containing 1..n Locations and each with 1..n Details. We can ignore the details for now as they are not part of the chart, but some additional data that is displayed when the chart is clicked...

I want to present a chart something like this:

6.0  |                                            |                                   |
     |       -------------                        |                    -----------    |
5.0  |      |             |-------------          |        -----------|           |   |
     |      |             |             |         |        |          |           |   |
4.0  |      |             |             |         |        |          |           |   |
     |      |             |             |         |        |          |           |   |
3.0  |      |             |             |         |        |          |           |   |
     |      |             |             |         |        |          |           |   |
2.0  |      |             |             |         |        |          |           |   |
     |      |             |             |         |        |          |           |   |
1.0  |      |             |             |         |        |          |           |   |
     |      |             |             |         |        |          |           |   |
0.0  |      |             |             |         |        |          |           |   |
      --------------------------------------------------------------------------------
                       Region 1                          Region 2

Where region 1 would have two location nodes in it, one with a name of Centerville and value of 5.5, the other with name of Leftville and a value of 5.0. Region would have two nodes, one with name Rightsville and a value of 5 and one with name Midtown and a value of 5.5.

The problem I am having is that I can't render a chart where bar1 of category 1 and bar 1 of category 2 don't represent the same name. If I had a Centerville in both region 1 and region 2, all is good. But that is not the case here.

Any ideas?