Changing how a check box user is displayed in a dashboard

3 posts / 0 new
Last post
Changing how a check box user is displayed in a dashboard


We have a customer who has added a checkbox udef to a report.  But it displays as checked\unchecked.  They would rather it say either Yes or No.  Or try to get the tick\cross images using indicators.  But they and I can't see how to achieve either of these.

Is this possible?



Frode's picture
Yes, it possible to change

Yes, it possible to change value on the column.

Two possible paths:

1. Create a calculated column in datacentral which changes the value. This option need a new column to be created.

2. The other way is to add an expression on the column like this:

Change UDEF35845 with name of your column.

=eval(   if('[UDEF35845]'=='checked'){
            }   else {


janegil's picture

In the datasett you probably have a row that gives you "Checked" or "Unchecked" like this:
/*cs*/, case   when udss.long21 = 0 then 'Unchecked'  when udss.long21 = 1 then 'Checked' else 'Unknown'end  AS [UDEF40469]/*ce*/

If you make a new column, using just the raw data - here that is udss.long21
Then you can use rangeindicators in the dashboard to get a checked icon.

Log in or register to post comments