It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Pocket Query; Google Charts API jumps out of any structure

I'm trying to build up a dashboard with several database based diagrams. The built in Confluence Diagrams a too poor in configuration, so I tried out the Google Chart API together with Pocket Query.

Everything works fine. But when I try to layout the position of several diagrams on one page, the diagrams seem to ignore the used structures (Confluence or html-Tables, Confluence page layout).

After editing in preview or final view, the diagrams "jump" out of their edited place and take place in other table rows or just jump out of the layout elements. I inspected the resulting HTLM code in my Browser (Firefox, updated) and found the generated code in other places than expected.

I use just the basic template for Goolge Charts API given in the PocketQuery documentation. We use Confluence 5.8.

Is there any solution or idea how I can "fix" the diagrams in the place where I placed them in edit mode?

4 answers

Hi Mathias,

I can suggest you to try Charts from Table macro that is part of Table Filter and Charts add-on. Maybe it can cover your needs.

I would really prefer to anticipate in searching for a solution without doing a full switch of tools first.

Hi Matthias! Thank you for using PocketQuery for your diagrams. I'll try to figure this out. Could you please post the storage format of your page? If you prefer to do this more private, you can sent it per mail to atlassian[at]scandio[dot]de.

Hello Felix,

by preparing a little example for you the problem "dissapeared". So I know that the problem is context sensitive. Hardening my surrounding generated HTML-Code (i. e. Links to attached pictures) helped.

To be sure that the diagrams are at the right place, method 1 from topic "Positioning PocketQuery.chart" works fine for me: when a chart shall be in a table cell I can give an ID to it an append the diagram there.

So let's stop spend time on this difficult problem.


BZW: a wonderful tool, congratulations! <offtopic>If I could use a (complex) query with more than one template (to guarantee same data used on different places in dfferent form) it would be gigantic!</offtopic>

Hi Matthias!

Ok, just get back to us if the problem arises again and you want it fixed! Thank you for your feedback, glad to hear you like PocketQuery! For your <offtopic> part, please feel free to create a new post here on Atlassian Answers and we'll have a look! Maybe what you want is already achievable! Also: if you like PQ, we'd be very happy about a review at the Atlassian Marketplace :smile:

Best, Felix

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

Expose your beautifully crafted Dashboard through the Jira Service Desk Customer Portal

  A picture is worth a thousand words, especially when you're trying to find relationships and understand your data. Here, Dashboards play a vital role in gaining insights from a variety of dat...

255 views 5 4
Read article

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you