How to create an As of Date field into a Dashboard to sort the Effective Employee at a specific date
Hope to find you well.
Our client ask us to add into a Dashboard's Page an As of Date field that can make possible to extract all the effective employee based on a specific date. The extraction, so, must be based on the employee's Effective Start Date.
I'm not so confident with the Dashboards, so i tried several times without succeeding.
- The Dashboard where the As of Date field must be active
- The Structure of the Dasboard page
- The Prompt of the Dashboard section
- The Analysis with the columns and filter
Thanks as always fot your attention and your time!