Last 5 Days in Table

choracy69

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

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

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

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

Below is the representation of same for choracy9.

Indravathi

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

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.