Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 230 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OAC - Auto selection of Current Date in List Filter
Hii OAC Community. As shown below ,In some of our visualizations ,We have List Filter having Date values of Data type:Date and Format :dd/MM/yyyy .We want to make sure that the selection of Current Date is done automatically .For this we tried with Parameters ,but we couldn't found the current date value as shown below.Pls suggest if this the correct approach ? also how to resolve this .Thank you.
Answers
-
You’re on the right track by using a date parameter to auto-select today’s date in your filter. For this to work, set your parameter’s initial value to an expression like CURRENT_DATE instead of a hardcoded date. Make sure your dataset always includes today’s date, otherwise the filter cannot select it automatically. If your data sometimes lacks the current date, consider applying a filter expression (YourDateColumn = CURRENT_DATE) or use the Relative Time Filter for best flexibility.
Hope this helps.0 -
Can you create a derived column in In your data model / dataset,
Example:
- CASE WHEN TRUNC("Your_Date_Column") = TRUNC(CURRENT_DATE) THEN 'Y' ELSE 'N' END AS Is_Today
- Now add this column to your canvas.
- Create a hidden filter Is_Today = 'Y' on to limit data to today’s date.
- Leave the List Filter for date visible, users can still change it manually.
0 -
Hi, to do this please set the data type to Timestamp and Auto, then set the initial value to the following Logical SQL:
SELECT MAX(CURRENT_DATE) AS Current_Date FROM
XSA('<REPLACE_WITH_YOUR_DATASET_PATH>')You’ll just need to replace
<REPLACE_WITH_YOUR_DATASET_PATH>with any existing dataset reference from your environment — that should do the trick.
I’ve tested it on my end, and it works fine.1 -
Excellent, thanks for sharing.
0 -
Thank you everyone for the responses, we'll test them one by one:
Dear @Jestin Rajan ,we tried with the approach ,however we are getting an error as shown below, Can you pls advise what mistake we're doing ? Thank you.
0 -
Hi, most of it looks good. The only part I can’t verify is whether the reference is correctly set up as the LSQL expects. What I’d suggest is — since the file name shows as _kpi_dataset, please go to Data > (3 dots) > Inspect, and you should find an option to Copy Object ID. That exact ID is what needs to be copy-pasted here.
1 -
Thanks @Jestin Rajan ,After using object id ,it's auto selecting the current Date .However it's now in Timestamp Format .We require it in the format :dd/MM/yyyy .We tried changing the parameter Datatype from Timestamp to Date and Format :Custom - dd/MM/yyyy and keeping the same Logical SQL ,but its not working, Pls advise on this . Also find some screenshots below for your info:
0 -
Glad it worked for you, @Hasan Sd ! What I’d suggest is to keep the parameter datatype as Timestamp (Auto), and then go to the visual and change the date format at the visual level from Auto to Custom (dd/MM/yyyy).
0 -
Thanks @Jestin Rajan for the reply .However we are not using Dashboard Filter Type. We are directly using Filters inside Different Visualizations as shown below :In this we can't see any option to change Filter Format to dd/MM/yyyy .Pls advise what we should now do to resolve this :
0 -
In this case, since you’re directly using filters within individual visualizations, you can try either of the following approaches to resolve the issue:
Change the data type from DateTime to Date in your data file (as shown in the snapshot). You can also set the required date format (dd/MM/yyyy) at that stage.
Alternatively, At workbook level create a custom formula using
CAST(<your_value_field> AS DATE)
and then bind this field to your parameter — ensuring both have matching data types.
0
