Triggers

[h_prakash]

Hi ,       

I have a dashboard with three sheets(A, B, C) and I have a Filter which is same across all the sheets. So if I select a options from that filter the metrics will change according to the selected filter across all  the sheets. I got a requirement where if I opened a dashboard first sheet A needs to be seen with a selected filter. 

For Example Three Sheets = A, B, C Filter has = Company, Sales, Output  Requirement = A sheet need to shown with Sales as filter selected when you open a dashboard. 

Thanks

Nag

[MayilVahanan]

Hi

Try like this

1. Open document properties

2. Goto triggers tab

3. Document Event  Triggers -> OnOpen -> Click add action

5. Add action-> Selection-> select in field

6. Mention field as Phase and search string as phase 2

7.Add action-> Active Sheet -> Give the overview sheet ID.

8. Click ok.

So whenever dashboard open, it select the Phase 2 value in Phase field and open the overviwe sheet,

Hope it helps

[Qrishna]

Please see attached.

Hope this will solve your problem.

[h_prakash]

Problem Solved..Thank you All..