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
Posted Friday in United States

Confluence Security Advisory

Good morning Members, Not sure if you are aware. Please read the following: https://www.icloud.com/keynote/0RyJ4VEdNUpjDpGfMhfZx9fEg#Confluence_Security_Advisor More details: https://co...

46 views 1 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you