I want to create columns in Frappe Insights based on the following conditions
Total Leads - All the leads
Contacted - Leads where status is not ‘Enquiry’ or ‘Open’
Interested - Leads where status is either ‘Interested’ or ‘Opportunity’ or ‘Quotation’
Quotation - Leads where status is either ‘Quotation’ or ‘Customer’
Converted - Leads where status is ‘Converted’
I was able to achieve this using raw SQL but the SQL scripts do not support filtering in dashboard so I will have to resort to Visual Query Builder. How can I make this possible?