Products
Webtrends Analytics 9.2 through 9.4.1
Webtrends Analytics 8.x
Issue
How do I change the currency symbol in performance dashboards?
Resolution
Dashboard configurations are stored in the xreport.xml file, found in the following location:
\Webtrends\storage\config\wtm_wtx\report_templates\rccommon
Each dashboard configuration has a “FormattingPatterns” configuration query
Sample Formatting Pattern query (this may appear different across versions):
tokenlist(currencyFloat,$#%25##0.00, currencyInt, $#%25##0,
Date, yyyy-mm-dd,
Float,#%25##0.00,
Int, #%25##0,
Percent, #%25##0%,
time, [$-409]h:mm:ss AM/PM;@,
timeElapsed, [h]:mm:ss;@,
URLdate, yyyy-mm-dd hh:mm:ss,
)
Rules:
1. In FormattingPatterns use “%25” (without quotes) to represent the comma.
2. Currency symbols other than the dollar sign ($) must be encoded. Substitute $ for one of the following examples:
(pound) = £
(euro) = €
(yen) = ¥
Example of formatting with :
tokenlist( currencyFloat,$#%25##0.00,
currencyInt, £#%25##0,
Date, yyyy-mm-dd,
Float,#%25##0.00,
Int, #%25##0,
Percent, #%25##0%,
time, [$-409]h:mm:ss AM/PM;@,
timeElapsed, [h]:mm:ss;@,
URLdate, yyyy-mm-dd hh:mm:ss,
)