Preselect a filter as user clicks on a certain KPI chart and go to a new view
Hi,
I would like to preselect a filter with specific name of a customer if the end user click on a KPI made for that customer. I have 7 KPI charts serving as banners for 7 customers. When the end user clicks on one, I want to take them to a new view where they see stats only for that customer - in essence for the filter to be preselected for the customer that was clicked.
Could you please point where you are? For me, This sounds like KPI click need to show different table. I can think Mashup here.
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
I can not use extensions as I am on the cloud version. Can you think of any work around without extensions. Yes, as we click on the KPI chart containing name of a person, I am taking them to a new sheet but then I want that sheet to be prefiltered by the name of a person they clicked on.
