I have this data(attached). It has multiple dates viz., [Open Time], [Resolved Time], and [Closed Time]. Whenever [Closed Time] is null, [Resolved Time] is considered as [Closed Time]. All are dates actually.
The requirement is that, whenever a day is selected, the number of calls logged on that day( count of open calls) and the number of calls closed on that day is to be displayed. Similarly, for any period selected, the charts should behave accordingly.
I have tried with both the functions with date variables and from_field , as per suggestions in the qvc.qvs forum.
Have attached the data and working stuff here.
Any suggestions, how this can be achieved?