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.
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
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.
Yeah that's easier approach, for some reason it did not strike
Below is the representation of same for choracy9.
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.
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.
Hello Oracle Analytics Community, We are investigating a dashboard compatibility issue between Oracle Analytics Server (OAS) 7.6 and OAS 7.0. Some dashboards originally created in Oracle BI 12c can be opened in OAS 7.6 but fail to open after being archived and imported into OAS 7.0. During our investigation, we found the…
Hi all, We’re running into an issue with an on-premises Oracle Analytics Server 2026 integrated with Active Directory and hoping someone has seen this or knows if a patch is available. Environment: Oracle Analytics Server 2026 (on-premises) WebLogic 14.1.2.0.0, JDK 21, Oracle Linux DB-backed catalog (Oracle DB, BIPLATFORM…
We have a requirement Creating a Bar graph using Cost Center Tree hierarchy as prompt/filter. Created a Bar Graph using Cost Center Tree Hierarchy as a prompt. When I'm selecting values through selection steps from Cost Center Tree Hierarchy, the Bar Graph not refreshing as the selected values are not passing to Graph…
I have 2 tabs on the workbook that use the same dataset. I would rather not use 2 different datasets. Can I code an expression filter or something to remove those records?
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4