Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Values Based on custom SQL
Summary
Values Based on custom SQLContent
I would like to display the Data for last 4 years based on data from initial setup.
Eg : Need to display value 100 for each of the rows in 2017,2018,2019 and 2020.
Able to bring the years , but the values are not getting displayed because , there are no values in 2017 till 2020.
Data configured in System :
Input Value | |||
Element Start Date | 1-Jan-16 | 100 | |
Element End Date | 31-Dec-12 | ||
Data Should look like below :
2017 | 2018 | 2019 | 2020 |
100 | 100 | 100 | 100 |
If the data changes in any of the year, it should display the new value.
Tagged:
0