pocketquery line chart question

my query results have some null values. i got an error about "All series on a given axis must be of the same data type". any idea how i can fix this? i tried setting interpolateNulls, it didn't seem to help.

12 answers

thanks Christian. but my intend is not to plot anything if the value is null, rather than converting null to 0. sorry for not making myself clear.

I think it's the best to remove the record through the sql query.

Hi! Is your issue still recent? If so, I'll have another look at it.

This appears to still be an issue. Is there a fix for this?

Have you tried to add a WHERE ... IS NOT NULL clause?

Felix, Thanks for the suggestion. I have a set of data like this: | Date | Low | Med | High | Overall | | 12/10 | 0.81 | 0.75 | 1.00 | 0.85 | | 12/11 | 1.00 | 1.00 | 1.00 | 1.00 | | 12/14 | 1.00 | NULL | NULL | 1.00 | | 12/15 | 1.00 | 1.00 | 1.00 | 1.00 | I'm looking to do a line graph so that the null values are simply omitted in the graph. Using a WHERE clause would eliminate a row with nulls altogether. I don't want NULL represented as zero (0) either as that would not be an accurate representation in the graph.

Hi Tim! The issue is actually in PocketQuery: as soon as a value of a column for the line chart is not a number (in this case null is not a number), the type for the whole column will become string. In that case, Google Charts won't work with the input submitted by PocketQuery. I added this as a bug in PocketQuery and I will target it with the next release.

Thanks Felix. Looking forward to the next release!

Hi Tim! Sorry for the harsh delay, this was not intended. We're about to release 2.1. Can you try if this early release of PocketQuery 2.1 works for your use case? Thanks!

Felix:  No worries, but unfortunately, this did not appear to fix the problem.

Hi Tim,

This is really strange. It works perfectly for me. Maybe you can think about what's different for you. I'm using PocketQuery 2.1-m6. I'm using the sample MySQL "World" database ( as dump file).

This is my statement:

SELECT Name, LifeExpectancy
FROM Country
WHERE Continent = 'Oceania'

This is my template:

<script>
PocketQuery.chart('LineChart');
</script>

Now, most countries in Oceania have a number in the column LifeExpectancy. But some of them have NULL. For the ones with NULL, there is a gap in my chart:

screen-pq-line.png

Maybe you can find out what's wrong with this?

Regards, Felix (Scandio)

Felix,

I'm using the version you are.  Here is what is looks like in table format.

image2016-5-4 12:18:50.png

When I do it as a line chart, I get the error.

 

image2016-5-4 12:20:17.png

Here is the SQL (using MS SQL 2012): 

image2016-5-4 12:27:33.png

Hi Tim, this is really hard for me to reproduce. Is this sensitive data? Maybe you could provide a database backup so I can reproduce better.

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
Published Tuesday in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

134 views 0 4
Read article

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