Hi, i would like to create a staked bar chart in Zoho Analytics where the x axis is the date of two different dependent date ranges.
The first date range is the date when a stage one payment is received in the CRM.
The second date range is the date when a stage two payment is received in the CRM.
The stacked bar chart should show the number stage one and stage two payments received each month.
The difficulty i'm having is that i need the X axis to show the date (month) relating to both the receipt of the stage one payment and the stage two payment. eg. there were 26 stage one payments in February and 6 stage two payments, so the stacked bar should show a total of 32. However, because this data is sourced from the same CRM module, the output i get when i set the x axis to 'date of stage two payment by year month' is a stacked bar which totals 12 (6 stage two payments plus the same stage two payments which have also paid a stage one payment).
I need the x axis to also show the number of stage one payments received that month which haven't paid a stage two payment.