Can I remove rows from my report, but still keep the aggregated total. See the attached sample for details.
Thank you for getting in touch. Do you have a few seconds to screen-share? If so please let me know what time works best for you.
Yes, I have time today. I am on the east coast, so maybe around 3 p.m., Est.
3pm EST sounds good. I will send you a ring central invitation now.
I am not entirely sure if this will work on your data, but I think that you should try creating a "Days between" pre-defined calculated field at the view level:
Advanced functions typically will work on top of the final data set so they cannot apply any aggregation that is not already occurring. However, since this is working as a calculated field it may be able to achieve your goals. Please let me know if you have any luck or questions on this.
Thank you, Nathan -- I will try this out.
Have you had any luck in resolving this?
Thanks for checking -- we were not able to find a solution via the View designer. It's a custom solution that we are working with -- might explain why.
Sorry to hear that. Would you be interested in scheduling a screen-share so that I can get a better idea of this specific case? If so please let me know what time works best for you. I am on the United States Mountain Time.
Hi Nathan, That would be great. I am busy this week -- maybe next week, Monday, if you have time?
Monday will work well. Let me know what time works best for you and I can send an invitation.
Is Monday at 4:00 p.m., Est. ok?
Sounds good, I will send you an invitation shortly.
Any luck getting this to work?
Working on it -- we're seeing the possibilities now.
Thanks for following up - the virtual table is nice! We can close this out now, thank you very much!
Glad to hear it Hugo. If you run into any issues, just respond and the case will be re-opened.
Closed Request Survey
Comments have been locked on this page!