Hello, I am having a brain freeze issue because I cannot think of a solution to the below - I am sure you guys will come up with something that will be obvious once it's explained to me lol.
So basically I have different sources of data, all containing the same format (i.e. column names) but each source is an updated version which contain the new status of the item. For example:
I need to somehow get this data together (preferably using data model relationships) and come up with a line chart that would show the number of items per date per status. A bit like the example below:
If you could explain how to join/relate the data, which fields for the chart (do we need to create helper fields?), etc... I would be very very grateful.