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 8 months ago
New

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:

a408eb7071e51aaa3cfb7209973466c6

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):

fd22e8cd2b4f4774465d84a8f4426415


I there a way I can aggregate data in the table while using the un-aggregated date field in the chart?