Several Questions to the home page lightning app builder:
1.) how can I change the displayed graphic from donut to gauge? I can't see any option and even if the report already uses gauge it is not possible to select.
1 a.) also the widgets are just randomly selected and not like I have defined in the underlying report.
2.)
in the lightning app builder to customize the home page layout, I cant select a specific report, its just not on the list:
all others i can select and it is displayed when using report chart component.
3.) Why can't I click on the report chart graphic and it will point me to the source report when navigation on the home page?
Thanks for quick help,
Philipp
Hi @Steve Molis
Above is the google chart that vizualized through the fornula field.Beolow is the formula field:
IMAGE("http://chart.apis.google.com/chart?chxl=1:|MTD|LMTD|YTD|LYTD|MAT|LMAT|YTD+Wsale|LYTD+Wsale&chxp=1,8,18,32,43,57,68,82,94&chm=N*0*,000000,0,-1,11|N*0*,000000,1,-1,11&chxt=y,x&chbh=50,5,25&chs=550x300&cht=bvg&chco=A2C180,3D7930&chd=t:"
+ Text(MTD_TY_Direct__c) + ","
+ Text(YTD_TY_Direct__c) + ","
+ Text(MAT__c) + ","
+ Text(YTD_TY_Wholesale__c) + "|"
+ Text(MTD_LY_Direct__c) + ","
+ Text(YTD_LY_Direct__c) + ","
+ Text(LMAT__c) + ","
+ Text(YTD_LY_Wholesale__c) +
"&chxr=0," + Text(MIN(MTD_TY_Direct__c,MAT__c,MTD_LY_Direct__c,LMAT__c,YTD_TY_Direct__c,YTD_LY_Direct__c,YTD_TY_Wholesale__c,YTD_LY_Wholesale__c)) + "," + Text(MAX(MTD_TY_Direct__c,MAT__c,MTD_LY_Direct__c,LMAT__c,YTD_TY_Direct__c,YTD_LY_Direct__c,YTD_TY_Wholesale__c,YTD_LY_Wholesale__c)*1.2) +
"&chds=" + Text(MIN(MTD_TY_Direct__c,MAT__c,MTD_LY_Direct__c,LMAT__c,YTD_TY_Direct__c,YTD_LY_Direct__c,YTD_TY_Wholesale__c,YTD_LY_Wholesale__c)) + "," + Text(MAX(MTD_TY_Direct__c,MAT__c,MTD_LY_Direct__c,LMAT__c,YTD_TY_Direct__c,YTD_LY_Direct__c,YTD_TY_Wholesale__c,YTD_LY_Wholesale__c)*1.2) + "," + Text(MIN(MTD_TY_Direct__c,MAT__c,MTD_LY_Direct__c,LMAT__c,YTD_TY_Direct__c,YTD_LY_Direct__c,YTD_TY_Wholesale__c,YTD_LY_Wholesale__c)) + "," + Text(MAX(MTD_TY_Direct__c,MAT__c,MTD_LY_Direct__c,LMAT__c,YTD_TY_Direct__c,YTD_LY_Direct__c,YTD_TY_Wholesale__c,YTD_LY_Wholesale__c)*1.2)
, "Sales Information"
)
Could you please let me know is there any way we can replicate the above chart in Salesforce without using google charts.
