def result_metrics
    chart = Ambling::Data::ColumnChart.new
    colors = %w{#0033CC,#FEC514}
    chart.graphs << Ambling::Data::ColumnGraph.new([],:title => 'Key Metrics',:color => colors )
    chart.series << Ambling::Data::Value.new("Connection", {:xid => 1})
    chart.series << Ambling::Data::Value.new("Facilitate", {:xid => 2})
    chart.series << Ambling::Data::Value.new("Influence", {:xid => 3})
    chart.graphs.last << Ambling::Data::Value.new($connectionVal, {:xid => 1})
    chart.graphs.last << Ambling::Data::Value.new($supportVal, {:xid => 2})
    chart.graphs.last << Ambling::Data::Value.new($influenceVal, {:xid => 3})
    render :xml => chart.to_xml
  end


  # GET /reviewrequests/1
  # GET /reviewrequests/1.xml
  def show
    @reviewrequest = Reviewrequest.find(params[:id])
    # flash[:reviewrequest_id] = @reviewrequest.id
    if @reviewrequest.sitereviews.count> 0
      @newest = @reviewrequest.sitereviews.last.created_at.to_formatted_s(:shortdaytime)
      @oldest = @reviewrequest.sitereviews.first.created_at.to_formatted_s(:shortdaytime)
      $connectionVal =
      (@reviewrequest.sitereviews.average(:response_1) +
      @reviewrequest.sitereviews.average(:response_2) +
      @reviewrequest.sitereviews.average(:response_3) +
      @reviewrequest.sitereviews.average(:response_4)) / 4
      $supportVal =
      (@reviewrequest.sitereviews.average(:response_5) +
      @reviewrequest.sitereviews.average(:response_6) +
      @reviewrequest.sitereviews.average(:response_7) +
      @reviewrequest.sitereviews.average(:response_8) +
      @reviewrequest.sitereviews.average(:response_9)) / 5
      $influenceVal =
      (@reviewrequest.sitereviews.average(:response_10) +
      @reviewrequest.sitereviews.average(:response_11) +
      @reviewrequest.sitereviews.average(:response_12)) / 3

    else
      @newest = "No Reviews yet."
      @oldest = "No Reviews yet."
      $connectionVal = 0
      $supportVal = 0
      $influenceVal = 0
    end
    respond_to do |format|
      format.html # show.html.erb
      format.xml  { render :xml => @reviewrequest }
    end
  end