Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
I have reports that im producing for a global audience what is the best practise for making sure:
Dates are formatted correctly
E.g.
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
E.g
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.
Regards
Andy
I hope this will be helpful: handling timezones and formats for date/time,number and money.
- Marcus
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)
NAME | DATE | VALUE |
---|---|---|
A | 04/20/2017 | 1,000.00 |
B | 04/15/2017 | 2,000.00 |
C | 04/17/2017 | 3,000.00 |
D | 04/01/2017 | 1,750.00 |
E | 04/07/2017 | 1,000.00 |
A user in the UK might want to see it like (Date formatted DD/MM/YYYY, Value #,##0.00)
NAME | DATE | VALUE |
---|---|---|
A | 20/04/2017 | 1,000.00 |
B | 15/04/2017 | 2,000.00 |
C | 17/04/2017 | 3,000.00 |
D | 01/04/2017 | 1,750.00 |
E | 07/04/2017 | 1,000.00 |
A user in Germany might want to see it like (Date formatted DD/MM/YYYY, Value #.##0,00)
NAME | DATE | VALUE |
---|---|---|
A | 20/04/2017 | 1.000,00 |
B | 15/04/2017 | 2.000,00 |
C | 17/04/2017 | 3.000,00 |
D | 01/04/2017 | 1.750,00 |
E | 07/04/2017 | 1.000,00 |
Any thoughts on this?
I got the requirement. I am saying i would suggest to go Ad Hoc reports with Country based for conditional enable. JAM He marcus_sommer may help for us
I hope this will be helpful: handling timezones and formats for date/time,number and money.
- Marcus
how do you recognize that user is from UK or Germany etc?
Interesting question.
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?