Search the Community

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"} ] } ] }

I have a page that filters a number of lists from a URL passed filter. How can I use this same filter to filter the collabion chart?

I am having a problem with a chart recognising dates from Excel correctly. I have a simple table in a spreadsheet which is published to SharePoint Excel Services. The table has two columns, the first are dates and the second numbers. I have selected the Excel file, sheet and table cells range in the Collabion Wizard and when I click View Data it shows the data from Excel incorrectly. In the Excel file the dates are in the format dd/MM/yyyy and are displayed as MMM-yy eg. 01/11/2012 => Nov-12 but in the View Data panel of the Wizard the same date is showing as 2014-11-12T00:00:00 How can I get Collabion to recognise the correct dates? Also, assuming the correct dates are shown how can I get the x-axis labels to show MMM-yy? I am using version v1.1.8 on SharePoint 2010 Enterprise.