Grouping by Date

Hello Byron Burton,

My name is Siddartha Pathi from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #{31992}
Case Title: {Grouping by Date}

Please allow us some time. We will get back to you shortly. If you have any further questions or need assistance, please reach out to us. We're here to help.

Sincerely,

Siddartha Pathi

Yellowfin Technical Support Engineer

Hello Byron Burton,

Greetings of the day

Thank you for your patience. I have attempted to meet your requirements using the Yellowfin user interface; however, I encountered the same issue you experienced. This problem arises because the aggregation of the column is being applied to the database rather than to the modified date column in the report.

To group data by date without considering the time, there is a viable option available. Kindly adhere to the steps detailed below to accomplish this task.

1) When publishing the report, click on "Report Settings" and toggle the checkbox for "Use as a View" to the "On" position.

2) Create a new report using the first report as the view.

3) Drag the relevant columns into the report.

4) Perform the aggregation on the date column.

I have attached a video for your reference. If you have any additional questions or need further assistance, please don't hesitate to reach out to us.

Sincerely,

Siddartha Pathi

Yellowfin Technical Support Engineer

Hello Byron Burton

I wanted to follow up with you regarding the solution I provided in my last email. Did the solution we sent you resolve the issue?

Please let us know if you need additional support on this issue.

Thank you,

Siddartha Pathi

Yellowfin Technical Support

Didn’t work as expected.  I was able to trim the dates using some Oracle SQL

Thanks

Byron Burton

UPS Innovation Center | Corporate Security

10 Upper Pond Road | Parsippany, NJ 07054

Phone: 201-828-6127 | Atlas: 5-283-6127

CONFIDENTIALITY NOTICE: The information contained in and accompanying this communication may be privileged or confidential and is intended solely for the use of the intended recipient(s). If you are not the intended recipient of this communication please delete and destroy all copies immediately.

New Comment

Grouping by Date [community.yellowfinbi.com] Siddartha Pathi [community.yellowfinbi.com] Hello Byron Burton I wanted to follow up with you regarding the solution I provided in my last email. Did the solution we sent you resolve the issue? Please let us know if you need additional support on this issue. Thank you, Siddartha Pathi Yellowfin Technical Support OPEN COMMENT IN BROWSER [community.yellowfinbi.com]

Stop receiving notifications [community.yellowfinbi.com] about this question

Hello Byron Burton,

Greetings of the day

Thank you for your response. Certainly, it is possible to accomplish this using SQL. However, I would like to remind you that we can also achieve the same outcome by utilizing the report as a view, as mentioned in my previous response. I am uncertain as to why it did not function on your end, but I am pleased to hear that you have found a solution using SQL commands.

Kindly inform me if we can proceed to close this ticket or if you require any additional information regarding this matter.

Regards

Siddhartha

Please close and thank you

Byron Burton

UPS Innovation Center | Corporate Security

10 Upper Pond Road | Parsippany, NJ 07054

Phone: 201-828-6127 | Atlas: 5-283-6127

CONFIDENTIALITY NOTICE: The information contained in and accompanying this communication may be privileged or confidential and is intended solely for the use of the intended recipient(s). If you are not the intended recipient of this communication please delete and destroy all copies immediately.

New Comment

Grouping by Date [community.yellowfinbi.com] Siddartha Pathi [community.yellowfinbi.com] Hello Byron Burton, Greetings of the day Thank you for your response. Certainly, it is possible to accomplish this using SQL. However, I would like to remind you that we can also achieve the same outcome by utilizing the report as a view, as mentioned in my previous response. I am uncertain as to why it did not function on your end, but I am pleased to hear that you have found a solution using SQL commands. Kindly inform me if we can proceed to close this ticket or if you require any additional information regarding this matter. Regards Siddhartha OPEN COMMENT IN BROWSER [community.yellowfinbi.com]

Stop receiving notifications [community.yellowfinbi.com] about this question

Hello Byron Burton

Thank you for confirming and giving us the opportunity to assist you with this case. We are glad that your issue is resolved. If you have any other issues, please contact us again by opening a new ticket, and we will provide additional support.

Thank you,

Siddartha Pathi

Yellowfin Technical Support