How to broadcast a report with selected time period (daily)? v 9.5.1

Hi Majeed,

Thanks for reaching out to Yellowfin Support.

Please find the below screenshots which will help you to schedule your report as per above mentioned timestamp.

Please follow below steps for schedule management.

Administration > Schedule management.

Once you are in Schedule management, Please select your report and you will find an edit option. Please follow the below options to specify the time.

Please let us know if you need any further assistance.

Regards,

Sri Vamsi

Hello Sri Vamsi

Thank you for the response.

I am aware how to broadcast a report in YF but the question is how we can show the data only for a particular time period in the broadcasted report?

I can see the only available options of time timestamp are last hour, last 12 hours, last 24 hours etc. but if i want to select custom time (for example from 09 AM to 09 PM) and broadcast daily, how can i do this?

Thanks.

Hi Majeed,

Thanks for your mail.

Can you please go to admin panel, under the Data filter period, can you please select certain parameters which ever you want in your report

Administration-> Admin console -> Date filter Periods

Note : If the report has a date range that exists between now minus 3 or 7, it is visible, otherwise, it does not show the dates that are available in the report.

Regards,

Sri Vamsi

Hi Majeed,

I just want to touch base to see if you had chance to read through my response. If you can let me know that would be great.

Regards,

Sri Vamsi

Hello Vamsi,

Thank you for your feedback on this, i am still need to understand from where i can customize the time (specifically) for example i need a report run from 04 PM to 10 PM of previous day and broad cast this daily.

thanks.

Hi Majeed,

As mentioned below, Can you please go to Administration-> Admin console -> Date filter Periods, there you can able to select or unselect the dates which you needed for report.

Regards,

Sri Vamsi

Majeed,

My two cents - if you needed to have a custom date/time range, you could build a couple calculated columns on the VIEW (must be in the view itself), then use advanced filtering to use where Effective Date Greater Than {Column} and Effective Date Less Than {Column} The columns would be your SQL expressions. Your specific code will depend on your version of SQL (e.g., this is T-SQL but you could do the same with any flavor).

Here are the StartDateFilter and EndDateFilter columns I created in a dummy view and set them in the screen shots below. Hope this is what you're looking for (incidentally, if you needed to change to start yesterday, could be done very easily with some changes to the code).

StartDateFilter = dateadd(hh, 9, dateadd(dd, datediff(dd, 0, getdate()),0))

EndDateFilter = dateadd(hh, 21, dateadd(dd, datediff(dd, 0, getdate()),0))

Hi Majeed,

Hope things are good on your end. Just wanted to check in to make sure you had what you needed here.

Regards,

Sri Vamsi

Hi Majeed,

I'm going to go ahead and mark this ticket as Completed due to inactivity at this time. Feel welcome to reach out in the future.

Regards,

Sri Vamsi