Hi i want to create Dynamic quicshight Rport i want to pass the userid parameter from my application in the url and want to generate report for that user only

Question & Answer
,
1

I am using MariaDB i am not able to bind the data in the querry using this (? or :param_name) and if i try to use filter parameter in analysis its not working

2

Hello @harini_trivedi, welcome to the QuickSight community!

When you say you are trying to filter dashboard using a parameter and it is not working, can you explain your implementation? As long as the filter is connected to the visuals and the parameter is linked to the filter, you should be able to programmatically pass the parameter value in on load. Alternatively, if you are not utilizing direct query for your dataset in QuickSight, you are not able to filter the query directly with the parameter.

If you are able to provide some more information about the errors you are facing, I can help guide you further. Thank you!

3

i have a userid parameter that i want to pass in the url of quick sight and want to create dynamic report for
the particular user

1 Like
4

Hello @harini_trivedi, yes, I understand. You said that it isn’t working though, so I was curious what you tried. If you apply a cross-sheet filter to all of the sheets in your analysis that is linked with the parameter, than this should handle the situation. Then, you need to add the parameter name and value at the end of your url (this is case sensitive).

It would look something like this:
https://us-east-1.quicksight.aws.amazon.com/sn/dashboards/dashboardId#p.ParamName=ParamValue

Make sure you use the #p. before adding the parameter name and parameter value to the URL. That should filter the dashboard on load!

5

Hello @harini_trivedi, did my previous response help guide you towards your desired output? If so, please mark my reply as the solution to this question. Otherwise, please let me know if you have any further questions on this topic and I can guide you further.

If we do not hear back from you in 3 days, I will close out this topic. Thank you!

6

Hello @harini_trivedi, since we have not heard back from you with any further questions, I will close out this topic. If you still need assistance with this, please post a new question in the community and link this topic to provide relevant information. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts. Thank you!