I have data that is in json format from the database, i want to draw a
graph with data but i'm not sure how to display it in my view in graph
format using the plotly library. My view code display nothing!
*CONTROLLER*
def dashboard():
call_clicks = db().select(db.dashboard.call_clicks)
social_clicks = db().select(db.dashboard.social_clicks)
profile_views = db().select(db.dashboard.profile_views)
data = {
'call_clicks': [c.call_clicks for c in call_clicks],
'social_clicks': [s.social_clicks for s in social_clicks],
'profile_views': [p.profile_views for p in profile_views]
}
data_json = json.dumps(data)
return dict(data_json=data_json)
*VIEW*
*This code displays nothing*
{{extend 'layout.html'}}
<div class="container">
Data
<canvas id="dashboard-chart" ></canvas>
</div>
<script src="https://cdn.plot.ly/plotly-latest.min.js";></script>
<script>
$(document).ready(function() {
// retrieve data from the server
$.getJSON('/default/dashboard', function(data_json) {
// Make sure that data is an object with the expected keys
{{if data_json:}}
// Get the data values
var call_clicks = data_json['call_clicks'];
var social_clicks = data_json['social_clicks'];
var profile_views = data_json['profile_views'];
// Create a new chart
var trace = {
x: ['Call Clicks', 'Social Clicks', 'Profile Views'],
y: [call_clicks, social_clicks, profile_views],
type: 'bar',
marker: {
color: 'rgba(255, 99, 132, 0.6)',
line: {
color: 'rgba(255, 99, 132, 1.0)',
width: 1
}
}
};
var layout = {
title: 'Data on the rate of interaction',
xaxis: {
title: 'Interaction Type',
tickfont: {
size: 14,
color: 'rgb(107, 107, 107)'
}
},
yaxis: {
title: 'Interaction Count',
titlefont: {
size: 16,
color: 'rgb(107, 107, 107)'
},
tickfont: {
size: 14,
color: 'rgb(107, 107, 107)'
}
},
showlegend: false
};
Plotly.newPlot('dashboard-chart', [trace], layout);
{{else:}}
console.log('Error: Invalid data received from server.');
{{pass}}
});
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/ef717b94-96ca-48c7-8829-147706f242een%40googlegroups.com.
