- What Grafana version and what operating system are you using?
Windows 11 Enterprise.
Grafana Cloud, newest version.
- What are you trying to achieve?
I am trying to create a simple table showcasing me Projects in Rows and or Columns does not mater, and then the occurrence of each individual status like (In Progress (3), Done (2) To Do (1) For “Project XYZ” and so forth.
- How are you trying to achieve it?
I have 3 Queries, linking to Jira Project management tool, which is based off a filter, which outlines only the various projects in statuscategory (To-Do, In progress and Done) - Reason im doing it in 3 queries, is because i cant receive more than 100 responses so doing pagination if needed and then merging the queries.
I’m typically starting with extracting fields and changing name, cutting down to only receiving Project and Status.
I have tried:
Using "Merge Series/Table
Filter to only show status/project
Grouping to Matrix…
I tried the “Join by Field” Outer also.
i’ve asked Copilot, ChatGPT etc. But their responses typically involve doing group by Project, and then doing a Reduce function by status column which doesn’t exist in Grafana, at least not for me.
I’m using the Infinity 2.0 Plugin.
- What happened?
I end up with examples such as a column with Projects, which has the same name (10 times) when i just want it once. However this got accomplished by using the matrix. However the problem now is, that either (1) It shows the various status names, or (2) it shows the status count, but only “once”, as it has not done any calculations previously based off the occurrence on the individual projects
- What did you expect to happen?
A matrix / Table showcasing me
Project A - (To-Do) = 2 - (In progress) = 3 - (Done) - 5
Project B Same…
Project C Same… (diff numbers)
