I would like to create a column chart, in GDS, that compare the monthly income versus unpaid amounts. In short, what was received versus what was not received and, what was not received, be added to the subsequent month.
Follow below how I parameterized the dashboard:
Datarange dimension: NULL
Dimension: Due_date Detailed dimension: I used a calculetad field to generate the open values and amounts paid. See below:
''CASE WHEN Due_Date < Pay_Date OR Pay_Date IS NULL THEN "Open" ELSE "Paid" END''
Metric: I calculate the total sum of payments: SUM(Bill_value)
Classified by: Due_Date
Secondary Classification: I used the same dimension of Detailed dimension
So, I think that the Detailed Dimension code is wrong.
