Currently, my focus is on creating a dashboard using backbone and highcharts. In order to display different charts on the front end, I am utilizing a MySQL server as the backend source of all the necessary data.
The approach we are aiming for involves having a Backbone model that can perform a fetch
operation, accepting parameters such as dateStart
and dateEnd
within the data
object to retrieve the complete data set.
Upon receiving the data set from the server, the goal is to store it locally for caching purposes. This stored data will be used to graph various elements with Highcharts based on different filters. The data structure returned by the server consists of an array of objects as shown below:
{
"dt": "2015-11-02",
"ad_product": "product name",
"environment": "mobile",
"geo_code": "country name",
"unique_users": "1",
"impressions": "1",
"all_engagements": "1"
}
Users should have the ability to apply filters like ad_product
, geo_code
, metric
, and environment
on the front end. Based on these selections, I aim to query the backbone model data with the specified filters to generate the series
array. This array will then be passed to the backbone view containing the Highcharts component.
I am currently exploring the best approach to achieve this functionality. Despite researching, I have not come across a definitive solution that aligns with my requirements effectively. Can anyone provide guidance on how to implement this seamlessly?