Parameter in Custom SQL

Q&A
,
1

I have a dataset having data for student x question x option (response by student). I want to visualize cross question stats (students who selected option X for Q1 and Y for Q2).

I have about 100K students and near to 500 question-options unique pairs so I don’t want to pre-compute all Q1 x Q2 combinations. (Pre-compute means creating a view in Athena from existing facts and dimensions tables)

I have tried-

  1. A pivot table having questions as columns and each row per student’s response. But, it takes so much manual effort (mainly to list 100+ questions) so doesn’t seem as an efficient approach.
  2. Custom SQL for picking Q1 and Q2 parameters in Quicksight Analysis but the new UI seem to have missing fields for parameters, so I got some errors around there.

I am looking for an optimal approach for this.

2

I was able to create a dataset using Custom SQL for my problem. But, still looking for a way to create Dataset Parameters in the new UI experience.

3

Hi @haripriyaa,

Welcome to the Quick Community! Based on the information you presented, I would recommend creating a parameter (Parameters section is located to the right of Filter button) to represent the field you want to depict. After adding one, you can click on the parameter’s ellipsis icon (right-hand side) to add a control, which will allow you to make a dropdown linked to one of your dataset fields. Lastly, create a visual filter in which you link the parameter from before like this:

image
image239×464 15.8 KB

This should enable you to display specific trends (like the Q1 and Q2 student options you mentioned earlier) without having to do further custom SQL. Let me know if this helps!

4

Hi @haripriyaa,

Just checking back in since we haven’t heard from you in a bit. Were you able to see my reply and/or find a solution yourself in the meantime? If you still have any additional questions related to your initial post, please feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.

Thanks!

5

Hi @haripriyaa,

Since we haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you!