Changing how a check box user is displayed in a dashboard

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

Hi,

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?

Thanks,

Trevor

Frode
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'){
                    'yes' 
            }   else {
                    'no'
             });

 

janegil
janegil's picture
Rangeindicator

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