Hi Team,
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:
RegistrationDate |
---|
12/1/2016 | 12/7/2016 | 12/7/2016 | 12/7/2016 | 12/7/2016 | 11/1/2016 | 12/5/2016 | 12/5/2016 | 5/9/2017 | 5/9/2017 | 11/15/2016 |
|
Any help regarding same is highly appreciated.
Thanks,
Ipsita