Issue with PocketQuery Templating with Google Charts

I'm having some issues with adding a tooltip to a Google Line Chart.  Here's what I have setup:

Query:

select date Date,  total  Total, 'example tooltip' from table

Results:

2014-05-01	255	example tooltip
2014-06-01	1232	example tooltip
2014-07-01	1981	example tooltip

Pocket Query Template:

<script>
PocketQuery.chart('LineChart', {
 height:700,
 width:1000,
 displayMode: 'text',
 pointSize: '3',
data.addColumn({type: 'string', role: 'tooltip'});
});
</script>

The issue is, the pocketquery results are blank.  I also don't see anything in the preview stack trace.  

 

Any ideas what I'm doing wrong?

Thanks!

3 answers

1 accepted

Hi Chris,

please check out version 2.0.1 from the marketplace. There is now a callback JS function beforeDraw in the chart method that you can use to manipulate the dataTable object before the chart is drawn.

Example query:

SELECT Name, LifeExpectancy, GovernmentForm
FROM Country
WHERE LifeExpectancy IS NOT NULL
AND Continent = :Continent
AND Population > :MinPopulation

Example template:

<script>
PocketQuery.chart('BarChart', {
	showTip: true,
	beforeDraw: function(dataTable, options) {
		dataTable.setColumnProperty(2, 'role', 'tooltip');
	}
});
</script>

The setColumnProperty call says "please make my column 2 the tooltip" (starting with 0). So in my query, the column "GovernmentForm" will become the tooltip.

Let me know if this helps!

Regards, Felix (Scandio)

Hi Chris! Just wanted to let you know I've seen this. It's actually not that straight-forward. I'll let you know about a solution during the next days. I'm interested in this very much myself ;)

Felix,

Thanks!  That worked perfectly.  I really appreciate the help and the upgrade to 2.x.

 

Chris

Hi Chris! Thanks for the feedback! Would you mind to contribute to the PocketQuery community and mark my answer as accepted? And would you mind leaving a review for PocketQuery at the marketplace?

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

914 views 23 12
Join discussion

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