Hello,
Hope all are fine.
I am working on a chart where data are coming from a mysql view. In the view there are 5 fields like customer_name, challan_no, challan_date, quantity. Sum of quantity value is showing as graph. I want to add a filter getting data from view. I want to sum of quantity value where challan_date = curdate() or Month(curdate()). I don not see any options to make this filter from chart options. I think i can do this filter from chart_rendered server event.
Can anyone suggest me how to make this filter for getting data from mysql view?
Regards
Emran