You need to sign in to do that
Don't have an account?
Emma Cherrington
How do I format the output of a SAQL query (Analytics) to include the $ sign and comma separators?
Hi,
Here is my query......
q = load "Plan_Number_MS";
q = group q by all;
q = foreach q generate sum('Plan') as 'sum_Plan';
q = limit q 2000;
p = load "Oppotunity_Inc_Martketing_Info";
p = filter p by 'ForecastCategory' in ["Closed", "Forecast"];
p = group p by all;
p = foreach p generate sum('ACV__c') as 'sum_ACV__c';
p = limit p 2000;
s = union p,q;
t = group s by all;
t = foreach t generate sum('sum_ACV__c') as 'thesumO' , sum('sum_Plan') as 'thesumP';
u = foreach t generate round((thesumP-thesumO),0) as 'Gap to Plan';
It is returning the right figure, but I need to format it as $1,234,567.......how do I do this please?
Thanks in advance
Emma
Here is my query......
q = load "Plan_Number_MS";
q = group q by all;
q = foreach q generate sum('Plan') as 'sum_Plan';
q = limit q 2000;
p = load "Oppotunity_Inc_Martketing_Info";
p = filter p by 'ForecastCategory' in ["Closed", "Forecast"];
p = group p by all;
p = foreach p generate sum('ACV__c') as 'sum_ACV__c';
p = limit p 2000;
s = union p,q;
t = group s by all;
t = foreach t generate sum('sum_ACV__c') as 'thesumO' , sum('sum_Plan') as 'thesumP';
u = foreach t generate round((thesumP-thesumO),0) as 'Gap to Plan';
It is returning the right figure, but I need to format it as $1,234,567.......how do I do this please?
Thanks in advance
Emma
Can you access the source JSON of your dashboard ? ( CTRL + E )
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_xmd.meta/bi_dev_guide_xmd/bi_xmd_format_currency.htm
The easiest way to build dashboards in Analytics is to use the designer. However, if needed, you can further customize dashboards by editing their JSON files. The JSON defines the components of the dashboard and how they interact.
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_json.meta/bi_dev_guide_json/bi_dbjson_intro.htm
All Answers
Can you access the source JSON of your dashboard ? ( CTRL + E )
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_xmd.meta/bi_dev_guide_xmd/bi_xmd_format_currency.htm
The easiest way to build dashboards in Analytics is to use the designer. However, if needed, you can further customize dashboards by editing their JSON files. The JSON defines the components of the dashboard and how they interact.
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_json.meta/bi_dev_guide_json/bi_dbjson_intro.htm
dataset{}
dates[]
derivedDimensions[]
derivedMeasures
0
field"Gap to Plan"
format
customFormat"[\"$#,###.##\",1]"
label"Gap to Plan"
showInExplorertrue
dimensions[]
measures[]
organizations[]
showDetailsDefaultFields[]
Best regards
Alain