Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
2 replies
Answers
1 answer
Subscribers
8 subscribers
Views
1728 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I have 2 questions, first is the yAxis value range determined by the values that
mikec
over 9 years ago
I have 2 questions, first is the yAxis value range determined by the values that it is exposing and can these be set with a currency symbol since the data I am exposing are dollars? Second, I have a column chart where I am displaying by year the annual amount that we spend on a vendor. This value is a decimal in the database (e.g. 650123.00). I want to show the data labels but this number is coming back like this: 650123. I attempted to add the dollar function but it has no affect. Here is my code:
a!columnChartField(
label: "Spend (in 1,000s):",
labelPosition: "ADJACENT",
categories: {"2013", "2014", "2015 forecasted"},
series: {
a!chartSeries(label: "Dollars", data: {dollar((rf!previousyear),2,1), dollar(rf!prioryear,2,1), dollar(rf!currentyear,2,1)},color: "GREEN")
},
xAxisTitle: "Spend by Year",
yAxisTitle: "Dollars",
stacking: "NONE",
showDataLabels: true,
showLegend: false,
showTooltips: true
),
OriginalPostID-142118
OriginalPostID-142118
Discussion posts and replies are publicly visible
Top Replies
PhilB
over 9 years ago
+1
suggested
A Score Level 1
Mike, I don't believe you can show currency symbols in those situations, but maybe the legend (showLegend) option would help - maybe set the label to "Spend ($)" and then switch the legend on? I might…
+1
PhilB
A Score Level 1
over 9 years ago
Mike, I don't believe you can show currency symbols in those situations, but maybe the legend (showLegend) option would help - maybe set the label to "Spend ($)" and then switch the legend on? I might even be considered the right place to show the dollar symbol , and the tooltip will show something like "Spend ($): 1000".
For your second point, it doesn't look like you can format the values - everything I've tried is ignored. If a value of, 1354.70 is entered, it will strip the trailing zero, but 1354.07 will display correctly.
Cancel
Vote Up
+1
Vote Down
Sign in to reply
Verify Answer
Reject Answer
Cancel
0
PhilB
A Score Level 1
over 9 years ago
Just another thought - you could also add a grid of the values below the chart showing them to several decimal places.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel