The CreatorCon Call for Content is officially open! Get started here.

Percentage calculation and display on data points in reports

Attila Beregvar
Kilo Sage

Hello Community,

 

Does anyone know if the calculation logic behind the data points on a report is accessible and can be changed? I would like to apply a custom logic how the % of each data point is calculated.

 

Or if not, can we turn off the display of the % value in the label of the data point?

AttilaBeregvar_0-1758626820680.png

 

Thanks!

 

6 REPLIES 6

TejasSN_LogicX
Tera Contributor

Hi,

Report data point % calculation is system-driven and not directly customizable. If you need custom logic, you’d have to build a calculated field or use a scripted data source before feeding it into the report. For display, yes—you can hide or modify the percentage labels by adjusting the report style options (Chart Configuration → Style → Data labels).

Hello, thanks for the reply! I was thinking the same about scripted indicators, but wanted to avoid using performance/platform analytics for this. 
Regarding hiding the %  labels only - I cannot find the option to turn them off. Please see this screenshot:

AttilaBeregvar_0-1758710653893.png

 

Bhuvan
Mega Patron

@Attila Beregvar 

 

It is possible, identify the formula indicator or scripted indicator for the KPI and change the formula logic or amend the script to calculate the score value. Please note, any changes to existing indicators would impact the presentation of scores in KPI dashboard. I would recommend creating a new indicator for the requirement, test it and create KPI dashboard.

 

I would not recommend changing the display value as it is out of box behavior. If you change indicator properties Unit to # it should only value but is not best practices and for % based indicators, it would make sense to display % along with scores.

 

Sample Formula Indicator for % as Unit

Bhuvan_0-1758627484732.png

For testing, changed to #

Bhuvan_1-1758627554306.png

Bhuvan_2-1758627626140.png

 

If this helped to answer your query, please mark it helpful & accept the solution. 

 

Thanks,

Bhuvan

Hello Bhuvan, thanks for the reply! My current report is not built with Performance Analytics or scripted widgets using indicators, it's a simple report with the standard reporting engine. 
I'm afraid the calculation logic wont be editable there, but at least I'm looking for a way to turn it off so it's not visible for the end user.