weekly data report — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

weekly data report

Received Response
21
Views
5
Comments
User_CEU9I
User_CEU9I Rank 5 - Community Champion

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

Truck Fulfilment

Truck Fulfilment

Truck Fulfilment

Transporter A

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

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

'=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

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Not quite clear on your requirement. Correct me if I'm wrong. Do you require to display data in a weekly format if Month is selected? What should happen if Year is selected without a Month value?

  • User_CEU9I
    User_CEU9I Rank 5 - Community Champion

    Hi,

    I have requirement like this...

    I have dashboard prompt with year (defaulted current year) and month (defaulted current month) as filters.

    I have two reports.

    1. yearly data (based on year filter).

    2. weekly data (based on month filter) - report shown as above - how to achieve this?

    Please let me know any further clarifications on requirement.

    Regards,

    Shubham

  • Joel
    Joel Rank 8 - Analytics Strategist

    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.

  • User_CEU9I
    User_CEU9I Rank 5 - Community Champion

    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
    Joel Rank 8 - Analytics Strategist

    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.