Hi!
Working with a developer and they are using conditional formatting +/- icons on a sum. For the value, they left it blank and it defaulted to a value called “Auto - Mid 50%”. What is this calculation and how can they emulate/calculate it in a visual to show the actual number that is being used to determine the conditional formatting +/- icons?
Hello @jay_johnson, there doesn’t seem to be any documentation on the default calculation for the conditional formatting logic.
My thought is it would be basing the 50% mark on either the median/average value, or potentially it is running a percentile calculation to return values greater than or equal to that number or less than. I’d recommend actually setting the conditional logic so you can display the values your calculation is based on.
We’ve tried calc fields using percentileDiscOver(sumOver)), sum()/count(), and avg() - the first two are shown in the KPI visuals above. Each of those numbers does not result in the +/- split were seeing using the “Auto - Mid 50%” conditional formatting value.
Hi @jay_johnson,
Just checking back in since this thread hasn’t received a response in a while. Were you able to find a solution yourself in the meantime or are you still facing the same issue? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!
Thank you!
Not quite. Still needing an answer to this. Would it be better to make a support ticket?
Hi @jay_johnson,
After looking further in to this scenario; I was unable to find any proper documentation that provides insight in to how they formulate the syntax that leads to this calculation. I know you mentioned that you tried the ‘PercentileDisc’ function, have you tested out the standard ‘Percentile’ or ‘PercentileCont’ functions to see if either of those provide an accurate outcome?
Hi @jay_johnson,
Just checking back in since this thread hasn’t received a response in a while. Was Brett’s reply helpful to you and/or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!
Thank you!
Hi @jay_johnson,
Since the percentile functions do not seem to be working for you, I would definitely recommend creating a support ticket with AWS Support, as they might be able to provide clarity on why the auto calculation is different and guide you further from there.
Thank you!
