cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
You can accomplish it via JavaScript - you could make the value appear in that format within the data point tooltip of the column chart widget i.e. the box that appears when you hover over the columns.
widget.on("beforedatapointtooltip", function (w, arg) {
  
  if (arg.context.pointScope.y > 0) {
    arg.context.points[0].value = "+" + arg.context.points[0].value;
  }
});
This is a widget level script for the column chart widget you wanted this formatting to be applied to.
Rate this article:
Comments
TJT
7 - Data Storage
7 - Data Storage

Is it possible to add dynamic data, basically a column from table instead of static text.

 

Thanks

TJ

Jake_Raz
10 - ETL
10 - ETL

Yeah, I was wanting to do the same thing @TJT mentioned. Is it possible to display this in a column of a pivot table? Right now I have three values: one for 2022, one for 2023, and the last shows the difference between the two (i.e. subtracting the 2022 value from the 2023 value). If something went down then it shows as a negative number, which I want, but if something went up then I'd like it to display a plus symbol. This way it's more clear that the values in this column are showing amounts of change, and aren't actual totals by themselves. I thought about formatting the last column as a percentage, but it's still the same issue: if it's a positive change, I want to show an explicit plus sign so it's better differentiated from the negative amounts.

DRay
Community Team Member
Community Team Member

Hello @TJT & @Jake_Raz.

First of all, sorry for the delay. I know this answer has taken a while. These posts from intapiuser were created by an automated migration and are not monitored.

That's a great question. If you haven't found an answer yet, please post your question in the Build Analytics Discussions section. We are happy to help you there.

Have a great day!

Version history
Last update:
‎03-02-2023 09:05 AM
Updated by:
Contributors