This object is in archive! 

Can I aggregate a date field in a report but use the un-aggregated version in a chart?

Ryan Navratil shared this question 11 months ago

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?