As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
I hope everyone is safe and healthy, I am trying to customize a bar chart labels to display in the specific format. I am trying to suffix values that are more than 1000 with K denomination and more than 1000000 with M etc. I have customized it to an extent where it will display the denomination correct, but not in the format I need exactly. I trying to do the following
1)display $12576.34 as $12.6K on the data labels and $760 as $760(which is less than 1000) 2) display data labels with same distance on all bars, not close not far. I tried using this to get that, but, no luck-setDataTextRadiusDefault(60); I have posted my code below and the output is PDF, Please provide if you have any inputs to do this.
GRAPH FILE wf_retail_tiny
-* Created by Info Assist for Graph
-*COMPUTE REVENUE/D12.2= WF_RETAIL_TINY.WF_RETAIL_SALES.REVENUE_US /1000000; AS 'Revenue'
WHERE WF_RETAIL_TINY.WF_RETAIL_TIME_SALES.TIME_DATE EQ '20160101';
WHERE WF_RETAIL_TINY.WF_RETAIL_GEOGRAPHY_CUSTOMER.COUNTRY_NAME EQ 'United States';
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET STYLE *
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
[B]setTextFormatPattern(getDataText(),"$ #.# K");[/B]
I was able to fix the 1st issue, Does anybody have information on how to put the data labels same distance from the bars in the above code. I tried using this setDataTextRadiusDefault, but, it did not move the labels. Please provide your inputs if you have any. Thank you.