How to create a chart showing ticket status by week?

[kvmanjunath]

Hi all, I am trying to create a dashboard or a graph where I want to show the ticket status by weekly. I am uploading a csv file in which I have 3 fields
1) Weeks --> Values are week1, week2, week3 and week4
2) Status --> Closed and Pending
3) Team_names --> Team1, Team2 and Team3

I want to create a bar graph which shows weekly wise along with pending and closed in a single bar for each team.

I tried the below query but it is not showing in a single bar

| inputlookup July_2014.csv | stats count by status, WEEKs, team_name

[strive]

What you need is stacked bar chart. Use this option

<option name="charting.chart.stackMode">stacked</option>

XML File

<dashboard>
  <label>Stacked Bar Chart</label>
  <row>
    <chart>
      <searchString>|inputlookup test3.csv | chart count by Weeks Status</searchString>
      <title>BarChartTest</title>
      <earliestTime>-3d@d</earliestTime>
      <latestTime>now</latestTime>
      <option name="charting.chart">bar</option>
      <option name="charting.chart.stackMode">stacked</option>
    </chart>
  </row>
</dashboard>

Sample Data:

Weeks,Status,Teams
w1,Closed,Team1
w1,Pending,Team2
w1,Closed,Team3
w2,Closed,Team1
w2,Pending,Team2
w2,Closed,Team3
w3,Closed,Team2
w3,Pending,Team1
w3,Closed,Team3

Sample Chart:

[somesoni2]

Teams have not been considered here. They need weekly stacked chart for status for each team. My guess is that chart overlay will be required (will have 6 series team (3) vs status (2))

[strive]

You said you need your values in single bar. That is the property of stacked charts. For that you need to set stackMode option.

I have also given search that you should use.

[kvmanjunath]

Sorry, I did not understand...