I'm stuck with something. I need to make a pie diagram with 2 values - how many projects are "ir saskaņots", and how many projects "Nav saskaņots". I can't figure out how to manage it. Adding 3 pictures, that may help to understand my issue.
Table with project status ----->>>
Table where I want calculation how many projects are "ir saskaņots" and how many are "nav saskaņots". And it should ignore information where fields are empty!
How chart should be, if I'll get any data!
II's not clear whether you want the issues count or project count, so I will try my best.
In the row dimensions bring in project dimension. In the project dimension search and bookmark the two projects you want the counts from.
In the measures dimension select issues created.
This gives you the count of issues in each project. Then select the pie chart view.
If you want statuses, replace the project dimension with the status dimension.