weekly data report

Question

Hi all,

I have the following requirement.

I have two filter parameters 1. year and 2. month.

If he selects month in the filter, report should display weekly data (based on month).

Note : It's cloud instance. I dont have access to rpd.

The report should display is in the following way.

Name of Transporter

Fiscal Week 1

Fiscal Week 2

………….

MTD

Truck Fulfilment

Transporter A

'=B/E= accepted shipments/ total # of shipments

Sum = w1+w2+..

Transporter B

Transporter C

When the user sees the truck fulfillment in Fiscal Week, they should be able to click on it to drill down to a day-wise view of the same.

How to achieve the weekly data based on month filter (it''s 445 calender)

If he select Jan month first 4 weeks should display and vice versa.

Regards,

Ram

Joel Acha · Answer

just add an is Prompted Month filter to this report and it should restrict the report the the prompted Month from Dashboard Prompt. It doesn't have to be a display column.

User_CEU9I · Answer

Hi,

My requirement is like this,

I have dashboard prompt with year and month columns.

I have two reports one is yearly report and another is month report. Both reports should be displayed.

I am clear on yearly report ..here i have year column in the report and made this column as Is Prompted so my report will filter based year column in the dashboard prompt.

I am not clear on the second report which is filter based on month you select (JAN, Feb,Mar etc) in the dashboard prompt.

My report does not contain month column. Report is having week column. Based on month you select, my report should be displayed all the weeks in that month. How to achieve this? I have given the week report in my first thread. Please see the report once.

Regards,

Ram

Joel Acha · Answer

so what are the conditions for displaying the yearly or monthly reports?

All you need is to put both reports on a dashboard in different sections and then you apply a condition on each section. The condition will determine whether or not the section is displayed.

To achieve this you could have a third dashboard prompt, maybe "Report Type" ( for example, which has 2 values:

Yearly

Monthly

The new Prompt should populate a variable and you then pass this variable to the sections described above.