Forum Discussion
Solved
add rows with fixed default values
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!
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.
2 Replies
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.
Thanks you! I applied your second solution and that works!
