How to display a boolean value in a Marix

[Quenjo]

Hi community,

I was wondering how to display a boolean value in a Matrix. This seems a really easy task but it does not work.

Let me explain it with an example :

This is what my table column looks like. Very basic, a simple boolean.

Now, when I insert it in a Matrix, it returns the "number of u_is_public" instead of just returning "True" or "False" where it should :

I have tried to change in the "visualizations" options but the only options here are : "Number" and "Number (distinct elements)"...

Do you have a solution to this issue ?

Many thanks,

Jonathan

[Syndicate_Admin · Accepted solution]

1. A simple solution would be to add a conditional column.
2. 
   
3. Keeping the text-like values.
4. 

   I assume that the data already has them of Boolean type. So you can do the same for Boolean values, create a copy of the column, text-like formatting.

Best regards.

[Quenjo]

@Syndicate_Admin 

Keeping them in text values worked !

When I imported the whole dataset, I reworked all the fileds so that they correspond to the value they contain. For some integer fields, without transforming the data from text to int I could not do the calculations with these fields. I thought that with boolean values it worked the same way.

Many thanks, for the answer ! Solved 🙂