Blend tables: Sum sales and Counting tickets

[gramsigurd]

Hello friends, I have the following problem and I’m having trouble solving it:

I have 2 tables:

Table 1: Total sales per day, by model and type of product;

Table 2: Open service orders (tickets) by date and model.

In the end, I need to generate a line graph with the accumulated sales and service order openings (month by month).

I tried to merge the two spreadsheets and generate the chart using date or model as “key”, but the values ​​always go wrong. Could they help?

Link das tabelas:

https://docs.google.com/spreadsheets/d/1zOwa8ykzuK7AcoOcwy8sM9_snKiE8ODkf66vcoj8iFs/edit?usp=sharing

How the graph should look:

Regards,

[sam8]

I think the main problem here is that you want to graph the data by month, but both tables aren’t grouped by month. Ideally, you’ll want to join on the date field in the blend (not the model field), but the timeframes would need to match up. Are you able to edit the daily table to get it to group by month? That would be the smoothest solution.