Creating a graph with measure from one table and calendar from different table

[Anonymous]

Hello everyone,

Im trying to create a graph that visualizes per week the time spent on a specific category and uses a measure of % Per Day. Currently, it gives an error because the Calendar table I'm using is not related to the results table.

I've attached how I expect it to look like and the data inside each table.

https://imgur.com/a/Ug4swF3

All help will be appreciated

[Anonymous · Accepted solution]

I figured it out, firstly I had to link the date in the Results Table to the Calendar table.

Then I needed to create a measurement that has the formula (Sum(%PerDay)/Distinct(Machine_id)) and finally i would filter by the needed category.