Forum Discussion

Jeyeline's avatar
Jeyeline
Helper 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
Super 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
    Helper 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
        Helper 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