Tuesday, August 14, 2012

Dashboard should show the corresponding graph according to prompt selection

Scenario:

I have a scenario where 

> The dashboard should show the corresponding graph according to prompt selection and should hide the rest of the graphs for which prompt is not selected.This should be achieved on ths same layout.
> Suppose say i have a prompt on Customer(A,B,C,....) and there is a dummy metric (1,2,3.....),

    - when customer 'A' is selecten in the prompt i have to see graph coresponding to metric1 
    - when customer 'B' is selecten in the prompt i have to see only graph coresponding to metric2 and rest of the graph should be hidden


Solution

The conditional formatting does not work on the graph itself. It works on sections for hiding an object.
Please perform the following steps

1. Add the graph to say for eg: Detail Header
2. Right click on the section and insert section below. Now the section will split into detail header 1 and detail header 2(For your eg you can split it into one more so that you get 3 sections)
3.Copy the same graph and paste it  in the section 2 within the detail header.
4. Now right click on detail header 1 i.e section 1  and place the conditional formatting and hide the object.
5.Similarly perform on all 3 sections.
6. When you run the report based on condition 2 graphs will be hidden and one will be shown but the placeholder for graph might be shown so right click on the sectio properties and check the property height can shrink.






2 comments: