Automatically generate one graph by fieldvalue

[#1]

Hi,

here is my problem.

I have one field "building", containing 5 values (5 different buildings), and another field "room", with many rooms (containing all the rooms in each of the 5 buildings). Once one building is selected, I would like to generate in a container one combo chart for each room that does exist in the selected building.

How can I do that?

Many thx in advance.

[jagannalla]

For my understanding your data will look like this.

Building, Room

    A, 1

    A, 2

    A, 3

    B, 1

    B, 2

    B, 3

    C, 1

    C, 2

    C, 3

Is it right means. Take in dimesion as Room and expr as Count(Building)

[#3]

Hey,

What i got from your explaination is:

1. You can just use getselectedcount(Building)>0 in the layout condition of container which would make the container visible when a building is clicked.

2. Then just create a combo inside the container having Building in the dimension and No. of Rooms in the Expression.

Hope this would help you.

Regards,

Neelam Singh

[#4]

Well, in my graph, I want to show something else, so for example, the expression would be 'electrical consumption' over dimension 'time'. So to answer Jagan, I would more have something like:

Building, Room

A, 1

A, 2

A, 3

B, 1bis
B, 2bis

C, 1ter
C, 2ter
C, 3ter
C, 4ter

(just to know that 1 for B or C are not the same than for A). But this is only for the choice of graphs. Thus, if I previously choose building A, I will have 3 graphs, 1, 2 and 3. Etc.

Hope that's clear enough.

[#5]

Still nobody with a magical idea? ^^