Showing results in percentage

[deepakqlikview_123]

Hi All,

I have values stores as 0.6,0.7,0.8 in my database.

But I want to show this line 60 %,70%,80% on chart.

For other chart

I have values stores as 6.0,7.0,8.0 in my database.

But I want to show this line 60 %,70%,80% on chart.

Additionally for one of chart

I have values stores as 60,70,80 in my database.

But I want to show this line 60 %,70%,80% on chart.

Can you please suggest because using num function for doing formatting changing results.

adjusting number format and showing results in percentage giving diff results.

Thanks

[#2]

Hello,

adjust all the values from your DB to single precision in LOAD statement.

For first chart - no need to change any. 0.6 = 60% after you apply % format.

For second do:

LOAD myValue / 10 as myValue

For third do:

LOAD myValue / 100 as myValue

Now apply same formatting across all charts and numbers.

[deepakqlikview_123]

Hi,

I have only one column as indicator name it  contains too many indicators and contains respective indicator value can u plz suggest how shall i go ahead.

Thanks

[sujeetsingh]

Change the number setting in properties>>Number Tab

[maxgro]

better to use the same for all percentage in your data model

I suggest 0.6 for 60% not a mix (0.6, 6.0)

number format:

- in number tab (image)

- or with num function: just copy the format pattern from number tab to second parameter

     num(count(TransID)/Count(TOTAL TransLineID), '#.##0,0%')

[Peter_Cammaert]

How do you decide whether a database column value of 0.6 means 60% (first chart), 6% (second chart) or 0.6% (third chart) ?

If you have a flag telling you row-by-row what to expect in this percentage column, first convert all values to a single scheme in your load script (e.g. values between 0 and 1 are best)

Then use the Number format settings from Massimo's screenshot below.

Best,

Peter