Forum Discussion

Jeyeline's avatar
Jeyeline
Icon for Helper III rankHelper III
2 years ago
Solved

Creating visualisation by summing the counts of two outputs

Hello Team,    We are fetching data from Azure DevOps analytic view where we have certain fields like Field Value Team Internal, External Reference Number Null, NA, unique IDs Null...
Need Help
Tips and Tricks
  • Jeyeline's avatar
    Jeyeline
    2 years ago

    Hi Anonymous ,

     

     Thanks for the reply. I tried this and I customized it 

    WorkItem1= CALCULATE (
         COUNTROWS( 'OKR'),  
                  'OKR'[Team]="External"
             )

     

     WorkItem2= CALCULATE (

         COUNTROWS( 'OKR'),  
                  'OKR'[Reference#] <> ""
             )

     

     And I combined the output by adding both to get the overall.

     

    Thanks!

     
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
Now we would like to have a visualization with an x-axis spanning months

I don't see a date column in your sample data

Jeyeline's avatar
Jeyeline
Icon for Helper III rankHelper III
2 years ago

lbendlin , the sample data

IDWork Item TypeCreated DateTeamReference NumberClosed Date
123Bug22-03-2023Internal 31-03-2023
124Bug22-03-2023External 1-04-2023
125Bug25-03-2023ExternalJ121-04-2023
126Bug25-03-2023ExternalJ131-04-2023
127Bug25-03-2023ExternalNA1-04-2023
    • Jeyeline's avatar
      Jeyeline
      Icon for Helper III rankHelper III
      2 years ago

      Hi lbendlin ,

       

       I want it to be line chart that shows the trend spanning months.

       

      X axis will be based on the Month 

      Goal is to determine, for example: for these months on axis Jan, Feb, Mar (created hierarchy)

      - Count of Work item (Bug) which satisfies the condition (y-axis)

      trend 1: Team must be External, Reference # equals either NA or empty

      trend 2: Team must be External, Reference # equals neither NA nor empty

      trend 3: Team must be Internal, Reference # equals either NA or empty

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Teach your users how to operate the filter pane.