Last 5 Days in Table — Oracle Analytics

Oracle Analytics Cloud and Server

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

Last 5 Days in Table

Received Response
21
Views
5
Comments
choracy69
choracy69 Rank 6 - Analytics Lead

Hi,

I have question about analysis.

How can I implement in table showing last 5 working days?

I have something like that at now:

pastedImage_0.png

And I want to show only last 5 days from this table --> 15,12,11,10,09.05.2017.

DAY is DATETIME column.

Answers

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    I think blow might give you desired result


    Create an additional column in your analysis and edit column formula of this column to change it as below and then put a filter on this column to limit number of rows to 5 using filters, make sure your date field is already sorted in descending order.

    EVALUATE('rownum' AS INTEGER)

    Please note you must have EVALUATE function enabled for use of above formula, below is 11g doc for the enabling Evaluate Function.

    https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/configfileref.htm#BIESG417

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

    If his results are ordered in the table by date (day), then there's no need to go with EVALUATE here.

    You can simply create an extra column with a formula RCOUNT(1) and then add a filter to the analysis such as RCOUNT(1) < 6. That should do what you need.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Yeah that's easier approach, for some reason it did not strike

    Below is the representation of same for choracy9.

    pastedImage_0.png

    pastedImage_1.png

  • Indravathi
    Indravathi Rank 1 - Community Starter

    Yeah, I agree with Pedro F up to creating RCOUNT(1) column . But   filter are not working ,filter should be an apply condition using selected panes.

    pastedImage_0.png

    I hope it helps you, If yes then click on like.

  • Indravathi
    Indravathi Rank 1 - Community Starter

    excuse me , filter is also working  , I have given filter as Rcount(1) is equal to/in 5 , result is in single row but for <6 it's woking .

    Thank you Pedro F.