I have reports that im producing for a global audience what is the best practise for making sure:
Dates are formatted correctly
US users like to see dates in MM/DD/YYYY format
ROW users like to see dates in DD/MM/YYYY format
Numbers are formatted correctly
UK users like to see numbers 1,000.00
German users like to see numbers 1.000,00
Any thoughts and recomendations on the best way to bring this kind of presentation into the reports.
Solved! Go to Solution.
Does your data fetching country level or world wide. If country level it may possible by using Ad hoc reports. But, If World data then could be a different approach. I am not sure whether that will work for Dashboard oriented
It shouldnt matter the report content or level its a user experience question.
Say I have a simple table in a report with 3 columns Name, Date and Value
A user in the US might want to see the table like (Date formatted MM/DD/YYYY, Value #,##0.00)
A user in the UK might want to see it like (Date formatted DD/MM/YYYY, Value #,##0.00)
A user in Germany might want to see it like (Date formatted DD/MM/YYYY, Value #.##0,00)
I have with my users a language attribute in the data so en-gb for UK users, en-us for US users de for German etc...
I'm looking for the most appropriate way to bring this into my reports.
Do I go the section access route?
Do I create a language group?
Or can I leverage the locale field in the user import file?
Or do I use a user filter on a report to pass the variable or create sesperate reports per language and group the users or apply a report filter?
Looking for the pros and cons of each approach?