Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Hi - great module!
I need to be able to graph progressive sales vs target, so the actuals time series will only have partial data at any one time.
Currently my graph won't show at all if I use null value, and zero values looks ugly - e.g. sales go up then drop to zero and flatline for the remainder of the period.
I am replacing a report in MSSQLServer - people's expectation (e.g.based on std Microsoft charts) is that it is possible to chart 2 series of different 'lengths', that null are simply ignored.I can't find anything in the SVGChart site or past Forena issues or videos to help.
Is there some FRX that can process null or hide 0 values?
Is there a method of combining 2 data blocks - overlaying them on the same axes?
Any help would be appreciated.
| Comment | File | Size | Author |
|---|---|---|---|
| #6 | nullgraphvalues-2347311-6.patch | 2.71 KB | metzlerd |
Comments
Comment #1
MickC CreditAttribution: MickC commentedComment #2
metzlerd CreditAttribution: metzlerd commentedIn the current development branch there are some new features that may help, depending on what your data structures look like. If you think you can develop a data block that returns data like #2337327: Multilinegraph using FrxCrosstab, then there maybe some help in the latest release for you. If not I need to know a little more about your data structure and your SQL query.
Comment #3
MickC CreditAttribution: MickC commentedThanks for the quick reply - the issue is a bit different to that other post - probably best illustrated with some ample data:
Week Target Actual
W1 1000 1019
W2 2000 1990
W3 3000 3141
W4 4000 3775
W5 5000 4833
W6 6000 6395
W7 7000 6977
W8 8000
W9 9000
W10 10000
W11 11000
W12 12000
W13 13000
Comment #4
metzlerd CreditAttribution: metzlerd commentedYes that helps... let me work on a patch for this problem. I think it's reasonable to assume in this case that null is not the same as zero, and that null values should be ignored.
Comment #5
MickC CreditAttribution: MickC commentedThanks David, that's great. Do you think it's going to be achievable with SVGGraph?
Given the graph won't render at all currently with NULL values, I tried but couldn't see any frx options anywhere for how to handle NULL.
If you can solve that then great, otherwise that's why I was asking whether it's possible to overlay 2 graphs on the same axes.
That option might have the advantage of being able to overlay different chart types as well e.g. line superimposed over a column chart.
First things first however...
Comment #6
metzlerd CreditAttribution: metzlerd commentedHere is a patch that was rolled against the current dev branch. The SVG graphing options were significantly updated so you will need to get 7.x-4.x-dev to before applying this patch.
There is no method of combining two data blocks on the same graph currently. That would be interesting I suppose but quite difficult to achieve, and would have still had the same problems in the existing code which was zeroing out null values because PHP graph didn't like them.
Anyway this patch will solve your problem and be committed shortly.
Comment #8
metzlerd CreditAttribution: metzlerd commentedComment #9
metzlerd CreditAttribution: metzlerd commentedFYI this is now fixed in beta 4 release.
Comment #10
MickC CreditAttribution: MickC commentedBrilliant! Thanks David, great result and fast turnaround.
The other comment was really about 'Mixed' or 'Combination' graphs e.g. Bar and Line, or Area and Line graphs.
e.g. https://developers.google.com/chart/interactive/docs/gallery/combochart
However this ticket is resolved so let's close this and I'll raise a new one about Combination charts.