Line chart

This is just a simple line chart with data from 2 different columns using a RawQuerySet source.

code

ds = DataPool(
        series=[{
            'options': {
                'source': MonthlyWeatherByCity.objects.raw(
                            "SELECT id, month, houston_temp, boston_temp "
                            "FROM demoproject_monthlyweatherbycity")
            },
            'terms': [
                'month',
                'houston_temp',
                'boston_temp'
            ]
        }]
)

cht = Chart(
        datasource=ds,
        series_options=[{
            'options': {
                'type': 'line',
                'stacking': False
            },
            'terms': {
                'month': [
                    'boston_temp',
                    'houston_temp'
                ]
            }
        }],
        chart_options={
            'title': {
                'text': 'Weather Data of Boston and Houston'
            },
            'xAxis': {
                'title': {
                    'text': 'Month number'
                }
            }
        }
)