Filtering JSON data by category

[natg504]

I'm using a 2D Stacked area chart with a json data source similar to the example below (but with a lot more dates).  I'd like to add a drop-down menu on the page that filters the data by date range.  Any suggestions on the best way to do this?  Thanks,

 

 

{
    "graph": {
        "caption": "My Chart"
    },
    "categories": [
        { "category": [
                {"name": "01/10/2007","showname": "1"},

               .....
                {"name": "10/15/2014","showname": "0"}
            ]
        }
    ],
    "dataset": [
        {
            "seriesname": "First Series",
            "data": [
                {"value": "771569"},

               ...
                {"value": "358887"}
            ]
        },
        {
            "seriesname": "Second Series",
            "data": [
                {"value": "7347"},

               ...
                {"value": "12596"}
            ]
        },
        {
            "seriesname": "Third Series",
            "data": [
                {"value": "40857"},

               ...
                {"value": "0"}
            ]
        }
    ]
}

Edited November 5, 2014 by natg504