I have multiple fields like opened,closed in my database.I have taken a KPI of these fields. Now i want that whenevr I click on the particular kpi ,it links me to the sheet where it shows me the corresponding emails of opened.that should be dynamic.
But I want to link the sheets dynamically.Like if I click on opened then it will redirect me to all the emails of opened.the emails were not present before.But when I clicked on opened it automatically redirects me.
If you follow the above example to click on a KPI object showing a measure for OPENED, you can have it take you to a sheet which gives details about 'OPENED'.
You can't pass a filter this way but there is nothing to stop you from putting a hard coded filter on the objects on the OPENED sheet.
Instead of count(ticket) you could have count( {<Status={'Opened'}>} ticket) ...where Status is a field in your data model and 'Opened' is a value that limits the count to just the Open tickets.
You'd have to duplicate the sheet and change the expressions for each tab . Not sure if that is dynamic enough ?
.png "Former Employee"){kind=icon}