Hi Team,
In my dataset, we have multiple date fields, but we now need to provide an option for only two date fields: received date and audited date. I created a parameter with the received date as the default value and added a control with a dropdown that includes both the received date and the audit completed date. I then created a calculated field, which is working as expected.
Now, we have a requirement where the overall count should always be based on the received date, and the audit count should always be based on the audited date.
For Overall count, we are using the following rule,
For audited count, we have written the following rule,
If we look at the snapshot below, the data is currently being fetched based on the filter selection. However, the requirement is to always show the overall count based on the received date and the audited count based on the audited date. Any suggestions here would be greatly helpful.
