Forum Discussion
Many to Many Join
I have two datasets I want to join so I can use a slicer/filter to show the total number of incidents based compared to the total number of hours on a job. Hours Dataset Job Name Date Total...
Hi jeffprandall
Create a Many to Many relationship like this:
then add Job name from Hours or Incidents to the slicer, then add total hours to the table with sum aggregation and Incident Type with Count aggregation.
the output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
I did Many to Many joins on the both the Job Name AND Date fields.
I put a slicer on the page that gets the Year from the Hours Dataset. It does a great job of filtering the Hours by Year but it's pulling random data from the Incidents dataset. I can't see a pattern for which records its pulling from the Incidents dataset.
