Can I aggregate a date field in a report but use the un-aggregated version in a chart?
I have a report with a hidden date field, and I want to aggregate records by client name so that each client is represented by one row:
However, I need to use the un-aggregated date in a chart, which I can't do unless I remove the aggregation. Which, in turn, splits up each of my rows into many entries (when i remove the aggregation of the date field):
I there a way I can aggregate data in the table while using the un-aggregated date field in the chart?