Search the Community

Hi there, When i try to group by a date column that is calculated to show week ending dates, I get an error that says the I have provided a large data set with more than 250 plotting points. If I use a non-calculated date column (the source for the calculation), I don't get this error. Can you either add 'week' to the 'group by' drop down, or suggest a way that I can get this to work? Thanks, -Blake.

First thing, Is this "Fusion Charts" or "Collabion Charts"? Are they the same thing? Am in the right forum? Apologies if this is misplaced. I am testing this out before using it in our SharePoint site and I have created a simple excel spreadsheet. A column of dates, and types of fruit. Each row is the total number of each fruit sold on that date. In excel I simply click the insert column chart button and a column chart appears with a # of fruit sold scale on the Y axis and the dates along the X axis with a group of all the fruit types columns for each date. Now trying to replicate this in CollabionFusion or whatever charts. Not so easy. The best I can do is, well I am not sure what it is I am looking at. I must be doing something wrong. I can't seem to tell it that I want all the types of fruit to show a column for each date. The Group and Drilldown configuration menu is not very intuitive for accomplishing this. Can someone point me in the right direction? I should mention that I am not using the spreadsheet in SharePoint. I have replicated the data as a custom list as the data source. Also, a side note. How do I get the chart to show the date in American style Month, day, year format? It seams as though despite selecting the date display format as 01/18/15, the chart will display the euro-style 18/01/15. Thanks for looking. Jeremy

I have a data set up in a SP list as follows; Plan (text) Test Date (date, e.g., 03/01/2012, no time) Responses (number, 0 decimals) Trying to group by Plan, show distinct value from Test Date with sum of Responses. When I group by Test Date (Quarter) and then distinct values from Plan it works fine. When I try to group by Plan first with distinct Test Date, I get a chart with no columns representing Responses. What am I missing? Thanks!