Last 5 Days in Table

choracy69 · May 16, 2017 2:38AM

Hi,

I have question about analysis.

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

I have something like that at now:

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

DAY is DATETIME column.

Syedsalmancs110 · May 16, 2017 4:36AM

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 · May 16, 2017 4:59AM

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 · May 16, 2017 5:31AM

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

Below is the representation of same for choracy9.

Indravathi · May 16, 2017 6:32AM

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.

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

Indravathi · May 16, 2017 6:45AM

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.

Oracle Analytics Cloud and Server

Categories

Last 5 Days in Table

Answers