I'm using the JIRA.JQL function but it is bringing unnecessary information on the first two lines, such as the time that was imported and the number of rows, this harms to generate graphics because I can not use the column header, help me?
Hi @Ricardo Plens ,
I think you can ignore the first 2 rows when generating graphs.
Let me know if the following works for you:
- Select all columns and insert a graph
- Right click on the graph and select "Select data source"
- Change the series values to start from the third row, e.g. change =Sheet1!$K$1:$K$282 to =Sheet1!$K$3:$K$282. Do the same for the Horizontal axis labels.
This should make the graph only take into account data from the third row (where the Jira data starts).
Alternatively, you could select the table manually (click and drag) before you generate the graph.
Would that work?
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event