I am importing Boolean tags but when I drag them on the power table, two of them show as decimals instead of 0 and 1.
What’s the number format set to on those columns in the table customizer?
Consider setting the “Boolean?” flag on all the columns in the table customizer.
The number format is the same as you have in the photo. By setting the “Boolean?” flag do you mean checking all the boxes in the table customizer?
Now, 4 out of the 6 Boolean tags are corrupted
You could change the number format to “0” and should then see only 0 or 1 in the cells. Or you could check the boolean option to display these as checkboxes in the cells.
I changed the aggregation mode from time-weighted average to closet value and that solved the issue!
1 Like
I was focusing on the display end, but that setting explains why you were getting decimal values in the first place and is a better solution. Glad you got it figure out!
1 Like