I am pulling jira data from gsheets and have come across a problem. i have created a stacked bar chart that shows the total number of bugs found per release, i.e. release number on x axis bug count on y axis. One of the challenges i am finding is where a bug has multiple releases associated with it, the bar chart treats that as one release and therefore creates a dedicated bar for it (see attachment). Any idea how to resolve where a bug has multiple releases associated with it, the count for it is split into the releases they are associated with instead?
Ah yes, another “slight problem” in Looker Studio — I love how every update turns simple charts into puzzles.
maybe try making a pivot in your google sheet (version release vs sum of total bugs) and connect that to your looker dashboard.
Hey,
Hope you’re keeping well.
In Looker Studio, the issue comes from how your underlying Jira data in Google Sheets is structured — if a bug has multiple releases stored in a single cell (e.g., “R1, R2”), the chart treats that as a unique category instead of splitting it. You’ll need to normalize the data so each bug–release pair is on its own row before charting. This can be done in Sheets using a formula to split values into separate rows, or upstream in Jira export by ensuring each release is a separate row in the dataset. Once the data is flattened, Looker Studio’s stacked bar will correctly aggregate counts per release.
Thanks and regards,
Taz