Showing More than one list in column or bar fusioncharts

[p38]

hi guys, any progress on this?

Paul

 

[cheesegrits]

Not really. Rob is gradually chipping away at the nvd3 viz, but I just haven't had any time to devote to working on the existing Fusion plugin.

-- hugh

 

[rob]

Ok whilst its not really in the spirit of how d3 does things I've had a go at implementing this on the server side in PHP, this wiki page explains the options that you would need to select to create the chart:
http://fabrikar.com/wiki/index.php/Nv3d_chart
You will need to update from github

 

[p38]

I'll give it a bash

Paul

 

[p38]

Hi Rob,

All graphs are working EXCEPT the Multiline Barcharts. The discrete barchart works.

I have tried all options, but cant seem to get it displayed.

Here is the link, and you are welcome to make any changes using the PM login details I sent you previously.

http://golfscore.co.za/index.php/live-results/live-statistics/graph-average-gross-nett-per-division


Here are fusion charts of the SAME data, except in 2 charts. What I want to do is to use your new graph to combine the 2 charts into one, with multiline barcharts

http://golfscore.co.za/index.php/live-results/live-statistics/list-stats-per-division

Paul

 

[p38]

Hi Rob, had a chance to look yet?

Paul

 

[rob]

hi Paul
I took a look just now, but the list's you are building the chart from (Stats - Per Division ) seems broken, when i try to view its data in the admin, i get a blank page.
That was to do with the plugin calls you were making in the list intro text. So I temporarily removed those (I've since added them back in), to see what the data was - but there was not data shown?

Does that sound right? I guess not but I'm not sure where to take things from here, any suggestions?

-Rob

 

[p38]

This is the viz to look at.

http://golfscore.co.za/administrato...m_fabrik&view=visualization&layout=edit&id=10

It uses the v_statsperdivision mySQL VIEW cause your new graphs work directly from the database, and not a list.

The list you were looking at will not show data as it has a userid prefilter, even in backend.

You will see this graph works for a normal discrete bargraph, but the multibar does not seem to, so I am guessing a small parameter error could be the reason.

Thanks,

Paul.

 

[rob]

ok so I re-created the viz on your site, and added some extra error handling to the code, and with that additional error handling it told me that you were trying to load fields that didn't exist.

so:

avg_total_gross as 'AvgGross',avg_total_nett as 'AvgNett'

should be

ave_total_gross as 'AvgGross',ave_total_nett as 'AvgNett'

I've not touched the original viz, just altered the test one I made which is labelled 'rob test viz', and can be seen here:
http://golfscore.co.za/index.php?option=com_fabrik&view=visualization&id=11

 

[p38]

Thanks Rob, typical copy and paste error that I did not pickup without any debug feedback.

The Error500 message is perfect as it will sort out any query errors that might exist, mine being a classic example.... and it saves us having to bug you all the time.

Thanks for your efforts in this regard, I have finally got a multiline barchart which I can now implement on the site. It looks like the new graph engine has plenty of scope for flexibility.

Perhaps add to your wishlist, it would be great if we had some type of access to change most of the graph properties via a script.....in this way, we as builders can then tweak visual display without you having to implemnt 1000's of property options...

Paul.

 

[rob]

Nice idea regarding the script.
I'm very much going by feel with this plug-in and only implementing things when needed, and when adding them I'm trying to be (semi) intelligent about how they are added. So that might be an addition I make when I need to do something a little marginal.