Hi,
I am following the instructions at:
https://leanpub.com/D3-Tips-and-Tricks/read#leanpub-auto-crossfilter-dcjs-and-d3js-for-data-discoveryand
trying to put this into web2py.
I created the database in the db.py, populated it with some data.
I have created a controller which queries the database, and created a JSON
view (default/dashboard_data.json) pulling this data back.
I have a view (visualisation.html) with the following code:
{{
response.files.append(URL('static','js/d3.js'))
response.files.append(URL('static','js/crossfilter.js'))
response.files.append(URL('static','js/dc.js'))
}}
{{extend 'layout.html'}}
<h1>Open source data dashboard</h1>
<p>Pie chart displaying percentages of each category in the database</p>
<div class='container' style='font: 12px sans-serif;'>
<div class='row'>
<div class='span12'>
<table id='dc-table-graph'>
<thead>
<tr class='header'>
<th>IncDate</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
<script>
{{# create dc.js chart object & link to DIV}}
var dataTable = dc.dataTable("#dc-table-graph");
{{# load data}}
d3.json("{{=URL('default', 'dashboard_data.json')}}", function (data) {
{{# format data}}
var dtgFormat = d3.time.format("%d/%m/%Y");
data.forEach(function (d) {
d.incdate = dtgFormat.parse(d.IncorporationDate);
});
{{# run data through crossfilter}}
var facts = crossfilter(data);
{{# Create dataTable dimension}}
var timeDimension = facts.dimension(function (d) {
return d.incdate;
});
dataTable.width(960).height(800)
.dimension(timeDimension)
.group(function(d) { return "Table"
})
.size(10)
.columns([
function(d) { return d.incdate; }
])
.sortBy(function(d){ return d.incdate; })
.order(d3.ascending);
dc.renderAll ();
});
</script>
I think the problem is with referencing the JSON file in the URL, but I
don't seem to be able to find the correct method of doing this in the book.
If that's not the problem, then I really have no idea where to begin!
If anyone could help at all, I would really appreciate it.
Many thanks
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
