Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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
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.
Still nobody with a magical idea? ^^