Hi Team, how can we format percentage values while downloading in csv to appear in the right format? For instance, 0.96% appears as 0.96% while downloading in Excel but when downloaded in CSV it appears as 0.96. Can we change this to appear as 0.0096 so it can easily be converted to 0.96% when users hit the % button
Hi @Tanisha_Shetty Assuming your raw data is 0.0096 which youâre formatting as a percentage within Quick Sight to be shown as 0.96%, are you saying when downloading this data in excel, it shows 0.96%, but in csv it shows 0.96?
Clarifying because I cannot replicate that in Quick Sight myself as when downloading in csv, I do see 0.0096
Hi @SD_QS,
Thanks for your response. I found my data to be 0.96 which is of type Number and is formatted as a %age.
Iâm unable to change this format currently, is there a way that I can retain the %age formatting while downloading this as a csv?
Thanks,
Tanisha
Hi @Tanisha_Shetty It looks like while your column is a number, a suffix symbol of â%â is used within the units section under âMore formatting optionsâ to display it as percentage in your visualization, is that correct?
Also, I am assuming when you say youâre unable to change this format, its because formatting the column as %age would show it as 96% instead of 0.96%, is that true? If thatâs the case, may I recommend that you create a new calculated field using your original column / 100 and format the new column as %age, such that when it is downloaded as a csv it will have the value of 0.0096 as you wanted?
Let us know if this helps, thanks!
Youâre right - âIt looks like while your column is a number, a suffix symbol of â%â is used within the units section under âMore formatting optionsâ to display it as percentage in your visualization, is that correct?â
Got it, thanks - I was looking for any cosmetic formatting options available to me which I could change. But looks like Iâll have to change the field itself.
Thanks,
Tanisha