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