Forum Discussion
Helper IIIChallenge is setting up a datamodel
Hi Jeyeline
I created a sample file. Below is a screenshot. You can download my sample file to see details. Hope it would be helpful.
The active relationships are on Created Date and Created By columns. The other relationships are inactive. Then use measures to calculate the Count values and use USERELATIONSHIP function to activate the inactive relationships.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Advocate IHello,
I think to solve this issue you have to create a separate Employee table with unique employee IDs and names. Link this table to the work item table using relationships for fields like Created By, Resolved By, Verified By, and Closed By. This will allow the employee slicer to filter work items based on the selected employee across multiple fields. Create measures or calculated columns for each visualization (Created, Resolved, Verified, Closed) to dynamically display the data based on the slicer selection.
Regards,
Ritesh
JeyelineThis is my final visualisation I would like to get.
If I selected the employee name, each of the visualisation should show unique results.
Example- Jeyeline has been selected in name, so the number of work items which is created by should be shown first, next will be the number of work items resolved by and similarly the number of work items closed by Jeyeline. Since the work items may vary, it should display the work item type as well.
On the other hand, if i selected the date filter as today, it should show
no. of work items created by Jeyeline on today(created on)
no. of work items resolved by Jeyeline on today (resolved on)
no. of work items closed by Jeyeline on today (closed on).
I could not make it possible with the relationships. Can anyone help us?Hi Jeyeline
I created a sample file. Below is a screenshot. You can download my sample file to see details. Hope it would be helpful.
The active relationships are on Created Date and Created By columns. The other relationships are inactive. Then use measures to calculate the Count values and use USERELATIONSHIP function to activate the inactive relationships.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!- Jeyeline
Hello Anonymous danextian
Thanks for your extensive support. Anonymous I have tried it with the reference you have shared. It works.
For all fields it is working as expected and I am able to get the data required. However for open parameter, if the calendar filter is for a year,it works. Whereas if I selected a particular data, the corresponding values are not derived. I am checking on it.
Thanks for your support!