Chart widget functioning wierd...
I have a report showing calculated numbers in 3 columns. The numbers come from the summary sheets on various project files. Other than the sheet name these are the only columns in the report. Trying to use the pie and donut charts it says they are not available for this data set. Trying to select the columns it only shows the last column (no matter how many are actually in the report), however, the all data is displaying in the chart?
Anyone know why this might be occurring and how I could get this to allow for a pie/donut chart.
Also, it's worth noting this same chart using the same fields will work on the individual project dashboards.
He who fails to plan is planning to fail. - Winston Churchill