I have a database which contains three fields: request_id, request_opening_date, request_fulfillment_date.
I need to show in the same bar chart the number of requests opened and closed by month (two separate bars per month).
For example: if a request was opened in January and fulfilled in February it would count +1 in the "January opened requests" and +1 in the "February closed requests". If a request was opened and closed in April it would count +1 in the "April opened requests" and +1 in the "April closed requests".
The problem is that, to count the openings I use request_opening_date as dimension, to count the fulfilled I use request_fulfillment_date as dimension and I can't figure out how to combine both in a single chart.
Try renaming the key field exactly as it was in the existing table. It automatically associates. But if you want to get into script then you can always unlock the script in load editor and transform and do the magic. 🙂