Forum Discussion

Jeyeline's avatar
Jeyeline
Icon for Helper III rankHelper III
1 year ago
Solved

Challenge is setting up a datamodel

Dear Team,     We are working with a datamodel integrated with Microsoft Azure Devops and Our Data model consists of workitem fields. Example, Bug, Task, etc. So each work item will have fields suc...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
Jeyeline
Icon for Helper III rankHelper III
1 year ago

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!