Forum Discussion

Mustafa_A's avatar
Mustafa_A
Contributor II
3 years ago

Dashboard - How to format numbers within SQL table editor?

Hello,  So we loaded some data to an application database, which we are accessing within Dashboard. Does anyone know how to format the table values in general? For e.g. I want the decimal to show i...
Dashboards
db_pdx's avatar
db_pdx
Valued Contributor
3 years ago

Hi Mustafa_A: you can generally use the same formatting strings as what is used in Cube Views.  Full navigation instructions: use the ellipse for the column you want to format.  The setting you want is under General > DataFormatString.  Use the ellipse again to bring up the object lookup.  Navigate to Number Formats and make a selection.

Cheers,  -DB

  • Mustafa_A's avatar
    Mustafa_A
    Contributor II
    3 years ago

    Thank you! db_pdx  ChristianW 

    I learned something new! That P0-P6 is a recognized formatting syntax in OS.

     

    Looks good now -