add rows with fixed default values

[ejpbiuser]

I have a table with clock in en clock out times per day where I have to calculate the duration for each worker and date.

For not every day of the week we have transactions and with a matrix or table it will not present the rows for the date/days without transactions.

How can I create fixed rows to have a fixed table in my report like below?

Thanks in advance!

[MFelix · Accepted solution]

Hi @ejpbiuser ,

There are two options that can work:

• Select the Dayofweek on option part of the visualization and click the small arrow on the rigth side and select the options show items with no data.
• If any of the values you calculate is a measure add a + 0 to your calculation and this will return 0 instead of blank so giving a value in the visualization.

[ejpbiuser]

Thanks you! I applied your second solution and that works!