Hallo,
I’m trying to make a matrix in bubble. In Excel it would look like this:
The grey cells are the hours I want to show. I don’t want individual cells, but cells in a repeating group, so it takes less time to adjust the summary in the future.
The blue cells are the users. They can be linked to the Hour table with a unique number.
The green cells are dates. It is like a table in Power BI where you can link dates to days and months. I want only the workdays in the summary.
In the user table are all the users. I only want to show some users with a specific variable.
The Hour table has multible records for each day and user. So a user can have more than 1 record per day. The hours need to be summed for each day and user. The information about the user is not in this table.
The Date input will at the top of the screen. They will filter the grey and green cells.
The problem is that I don’t know how to make a matrix without using individual cells. I would like to use repeating groups.
I tried to use the current cells index, but this method failed. The reason was that some days won’t have records. This makes it so that the date table doesn’t correspond with the grey cells.
Does someone know a solution for this problem?