Calculated Columns in Pie Chart depending on date filter
Posted: Tue Apr 16, 2013 12:56 pm
I want to have a report which is showing the pie chart of three columns depending on the date filter and employee I've made. So, I have datetime filter on a datetime mysql format which is giving me amount of hours in some date range, same for the employee name. I have field working hours, driving hours to and driving hours from. All these are decimal type. I just want those 3 fields to be shown in a pie chart and to be summarized (summarized columns). I've made the calculated columns, but when I add 3 series in a pie chart (every serie is a calculated column) with value data column that is calculated I can't get it running. It crashes. On the pic you can see the structure. Filter data source is for filtering, I get the name of all employees and than just print the one that is selected in the filter in databand2. Then in databand1 I connect the user.login==filter.login so I can get the date and time of activities per selected employee. And than there is this unlucky pie chart in separated databand since if I would put it in databand2 it would be printed multiple times, depending on the date filter (for example 10 days - 10 pie charts). Now the only thing running is when I assign series to non-calculated columns for work and driving but then if I have 10 dates I get 30 values in a pie chart (3 time columns). Unfortunately, I can't send the data since it is sensitive. Help 