I need help to achieve the result for below formula. Can you please let me know what would be the correct expression so that i will get the result for the progress% of my application. I have not used script loading. I have loaded my DB tables through data manager. so i need correct expression to apply to get the result.
Progress (in days) = ( Current Date - Average RegistrationDate)
I have taken Date as in Filter visualization.
Current date would be like whatever value I am selecting from Date filter. It can be the current system date or can be any other date which I will select from Date filter.
RegistrationDate will be like follows:
Any help regarding same is highly appreciated.