I noticed that there are From_date and to_date in multiple tables, which creates synthesis key. Also how you are getting from and two date?
Why you are arriving same fields for example (INQUIRY_RECEIVED_DATE) multiple times as two different fields?
Generally in this situation, I will provide 2 date objects for selecting From and to and assign it to a variable. By using set analysis I will filter the data based on the above selected From and to dates.
If possible I wil provide an example sooner.
Yes, Jagan!! You got the point...it's kind of set analysis which will be not independent selection for all the charts and other object. And my intention is to use independently rather than making a chart expression with set analysis. Could you please drill down further more to provide me better solution. Best Regard,