def chart(request):
dataset = Indicators.objects.values('indicator','target','progress')
indicator = list()
target = list()
progress = list()
for entry in dataset:
indicator.append(entry['indicator'])
target.append(entry['target'])
progress.append(entry['progress'])
target_series = {
'name': 'Target',
'data': target,
'color': 'blue',
}
progress_series = {
'name': 'Progress',
'data': progress,
'color': 'red'
}
chart = {
'chart': {'type': 'column'},
'title': {'text': 'Indicator Analysis'},
'xAxis': {'categories': indicator},
'series': [target_series,progress_series]
}
dump = json.dumps(chart)