Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Button handy
blanktrue
color#0052CC
nameSend Feedback
linkhttps://docs.google.com/forms/d/e/1FAIpQLScmToBe3vynAlb5fdKwCGxYqnTbDc66sIBgeecG2BuFDuHc7g/viewform?entry.2002826954=Opened+vs+Closed+Issues+Report+-+15481450
widthauto

The report is a bar chart showing the number of opened issues vs number of resolved issues for a given list of projects. 

Code Block
$! 
 string [] project = argv[ 0 ]; 
 number resolvedIssues = countIssues( "project = " + project  +  " AND status in (Done, Closed, Resolved)" ); 
 number openedIssues = countIssues( "project = " + project  +  " AND status not in (Done, Closed, Resolved)" ); 
 number totalIssues = resolvedIssues + openedIssues; 
 
 number prResolved = round(resolvedIssues/totalIssues *  100 ,  2 ); 
 number prOpened = round(openedIssues/totalIssues *  100 ,  2 ); 
 $ 
 
 <html> 
 <head> 
 <style type= "text/css" > 
 body{ 
    background:#ededeb; 
 } 
    
 .report{ 
      font-family:  'Source Sans Pro' , sans-serif; 
      color: white; 
      box-shadow: none; 
      display: -webkit-inline-box; 
 } 
 .report ul{ 
      margin:0px 30px 10px 0px; 
      padding: 0 ; 
      list-style-type:none; 
      font-size:11px; 
      font-weight: 400 ; 
      line-height:20px; 
      } 
 .report_box{ 
      width:  85%; 
      background: #42526e; 
      float : left; 
      box-shadow: -1px 0px rgba( 255 ,  255 ,  255 ,  0.07 ); 
      cursor: pointer; 
      transform: scale( 1 ); 
      transition-property: transform,background; 
      transition-duration: .3s; 
      max-width: -webkit-fill-available; 
 } 
 .report_box_inner{ 
      padding:30px; 
 } 
 .report_box_inner span{ 
      font-size:36px; 
      font-weight: 700 ; 
 } 
 .progress{ 
      width: 100%; 
      margin-top:10px; 
      height:6px; 
      background:rgba( 0 ,  0 ,  0 ,  0.3 ); 
      margin-bottom:15px; 
 } 
 .progress_bar_opened{ 
      height:6px; float :left; 
      width: $prOpened$%; 
      background:#e4da57; 
      -webkit-animation:bar 2s; 
 } 
 .progress_bar_closed{ 
      height:6px; float :left; 
      width: $prResolved$%; 
      background:#1c9c6b; 
      -webkit-animation:bar2 2s; 
 }  
        
 .report_box_inner h2{ 
      font-weight:normal; 
      color: white; 
      font-size:16px; 
      margin:-4px 0px 3px 0px; 
 } 
 .report_box_inner p{ 
      font-size:11px; 
      color:rgb( 182 ,  182 ,  182 );clear: left; 
      font-weight: 300 ; 
      width:160px; 
      margin:2px 0px 15px 0px; 
 } 
      
 
 </style> 
 </head> 
 <body> 
 <div  class = 'report' > 
    <div  class = 'report_box' > 
      <div  class = 'report_box_inner' > 
        <h2> 
          Opened issue in $project$ 
        </h2> 
        <div  class = 'stat' > 
          <span>$prOpened$</span> 
        </div> 
        <div  class = 'progress' > 
          <div  class = 'progress_bar_opened' ></div> 
        </div> 
        <p>This is a simple example. You can render any html and  do everything you want.</p> 
      </div> 
    </div> 
    <div  class = 'report_box' > 
      <div  class = 'report_box_inner' > 
        <h2> 
          Closed issue in $project$ 
        </h2> 
        <div  class = 'stat' > 
          <span>$prResolved$%</span> 
        </div> 
        <div  class = 'progress' > 
          <div  class = 'progress_bar_closed' ></div> 
        </div> 
        <p>This is a simple example. You can render any html and  do everything you want.</p> 
      </div> 
    </div> 
 </div> 
 
 </body> 
 </html>

...