Could you please share your sample workbook, I think you missed something other wise it works very well . I implemented the same in my couple of dashboards.
thank you for responding.
Because the original workbook I was working with contained sensitive data, I cannot post the original. Instead I attached a file that read similar data from an excel file with a sheet modeled the same as my original.
You can correct me if I'm wrong but will this change anything? In my original worksheet I pulled data from a mysql database, so within the data loading query I could have wrote a statement like SELECT * FROM table WHERE userid = <Parameter.userid>. However with this worksheet i'm pulling data from an excel file.
If you take a look, some userids have answered certain questions, and for me to be able to pass a userid as a parameter into an embedded url and load only the questions that specific userid answered is what i'm looking to do.
if you can help please let me know,
I imported Sample Super Store Data in m SQL data base
and tried to achieve the same, please find attached workbook. If you prompted for password please enter 123456
Once you go through please let me know so that I can delete / drop the user id which I am sharing with you.
Live Connection.twb 36.7 KB
I took a look at your file and played around with it. Just to ask a question, so what i'm seeing is when I toggle the parameter in the sheet, the dashboard changes to display that data based on that parameter.
This is definitely a step into what i'm looking for. Would publishing this sheet/dashboard, embedding the link into an iframe and passing the parameter Region=North at the end of the url show when the sheet/dashboard loads on the web app?
Thank you and you can delete/drop the userid
1 of 1 people found this helpful
I got it to work. Thank you very much, I appreciate it!