Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement wherein there is a straight table chart with dimension called metric name when i click on the data present in that column (say i click on metric_a)it shud take me to another sheet which has a text box with sum(value) for metric_a.similarly when i click on metric_b in the straight table of the 1st sheet it shud take take to another sheet which has a text box with sum(value) for metric_b.
I have attached the sample application.Please let me know how this could be acheived
Anushree
Use a Document [or Sheet] level Trigger:
Settings
Document Properties
Triggers
Field Event Triggers
Then set up as per your needs
Best Regards, Bill
May be like attached sample?
Hi Anushree,
If everytime after selecting a value in field "Metric", you want to land on the same sheet (The one which contains Sum) then you can use Actions/Triggers.
You can got to Settings--Document Propeerties--Triggers--Field Event Triggers (As Bill has mentioned in his answer)
Here you can add an action Onselect & Onchange of the field.
Action Type : Layout
Action : Activate Sheet
You can tweak this logic per your needs.
Hope this helps!
In the attachment put up you have hard coded the scenario as
=
If(Fields='Amount1', 'SH02',If(Fields='Amount2', 'SH03'))
So incase a new field called amount3 is added at the backend you will have to change the code to add it again.But I want this to be dynamic like when a field value is selected on the chart it should take to another sheet providing me with the detailed analysis.
But in the approach used here,if there 10 such fields we will have to put in a nested if and this goes on as the number increases.is there any other better turn around option for this?
Try this one. You have to change the sheet names as well.
Anushree
If there are backend changes, like say adding a new database column to be used as metric, then that by definition will require amending your qvw, especially the script.
Best Regards, Bill
Hi,
You could change the Sheet Id as your FieldValues. Then You can simply use =Fields
PFA
Thanks for the suggestion.But i have another constraint,as we have set these properties at document level this activation holds good for all the sheets.But i do have other sheets referencing to the same fields and when i click on them,i still navigate to the respective sheets, which should not happen so can we make this property to be valid only on particular sheet? and not apply to all of them