Pocket Query; Google Charts API jumps out of any structure

[Matthias Schmenner]

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?

[Felix Grund (Scandio)]

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 

Best, Felix

[Matthias Schmenner]

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.

Matthias

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>

[Felix Grund (Scandio)]

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.

[Andrey Khaneev _StiltSoft_]

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.

[Felix Grund (Scandio)]

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