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...
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.
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!
