Relationship Between Main Query and "Grouped" Query

[tteo]

Hi Everyone,

I recently duplicated my main query to group data to fit my required visualizations, and am having trouble linking the two queries for them to interact with one another.

Here are the fields in the main query: Serial No, Date Taken, Positive Or Negative Result, and other fields irrelevant to the other query.

Since serial numbers can be duplicated, I decided to duplicate this main query and group the items according to serial no and only positive results in order to see how many positive results each serial number has gotten. I also get the total number of results to see % of positive results.

Since the date was left out, the visualization is unable to interact with a date slicer as well. Is there anyway to relate these two queries together? Thank you.

[jaideepnema]

Hi @tteo ,

Not very clear but I would suggest instead of creating a new query you can also try creating a visual where you can count positive results by each serial number. You have to apply the visual level filter to only take positive results or else you can also try creating a measure for the same.

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/