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!

     
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

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Teach your users how to operate the filter pane.

    • Jeyeline's avatar
      Jeyeline
      Helper III
      2 years ago

      Hello lbendlin ,

       

      We cannot accomplish this via the filter pane. Applying the first filter automatically filters the first level of records, hence there is no use in applying the second filter.

      Our expectation is related to getting two separate outputs and combining both.