Chart Format - Percentage

Drew Goddin shared this question 3 years ago
Answered

I've formatted a data column as a percentage and it looks fine. When I graph the value it defaults back to the decimal and the vertical access shows 0.XX. Is there a formatting option I'm missing?

Comments (4)

photo
1

Hi Drew,

Thanks for reaching out. It's possible something is being missed, but I require more info to provide further support: What chart type are you trying to use? When you say you have a data column formatted as a percentage, do you mean you have Format under Display set to Numeric, set Decimal to 0, and have Suffix as %, like so:

/AfHb8VKDp2YXAAAAAElFTkSuQmCC

Or do you mean you have the Format set to Percentage?

/fuHUxxlZWABCQgAQlIQAISkMCwBaZNmzbsOvxsNtvZYdeiCiQgAQlIQAISkIAEJDCCBTS9YQRfHIUmAQlIQAISkIAEJOAbASW9vnFULRKQgAQkIAEJSEACI1hASe8IvjgKTQISkIAEJCABCUjANwJKen3jqFokIAEJSEACEpCABEawwP8PeJ4rwXhDe3sAAAAASUVORK5CYII=

Thanks,

Mike

photo
2

Mike, I have the later ... Format Percentage and then when I create a line graph it doesn't carry the formatting over. I'm trying to get away with not having to multiply the column by 100 to get the format on vertical axis correct. I'm hoping there is a simple answer that I'm overlooking. thanks.

photo
2

Visual of the issue


/ZtKWZK2EwP8DhkMW1CKCcqYAAAAASUVORK5CYII=

photo
1

Hi Drew,

Thanks for your response. Please head into the Axis settings and choose the Vertical axis and add "%" as the Suffix:

/J2z4P8YWLxAydKYbAAAAAElFTkSuQmCC

/Ju7nVJofuPBfTWJx5L+alK7wR3x4DH8dxuuvv55uCNpAwFUC+Byjq7ixGAiAgAoEkEqrECXYCAIg4CoBCKOruLEYCICACgQgjCpECTaCAAi4SgDC6CpuLAYCIKACAQijClGCjSAAAq4SgDC6ihuLgQAIqEAAwqhClGAjCICAqwQgjK7ixmIgAAIqEIAwqhAl2AgCIOAqAQijq7ixGAiAgAoEIIwqRAk2ggAIuEoAwugqbiwGAiCgAgEIowpRgo0gAAKuEoAwuoobi4EACKhA4P8Dw2OOo6K64RkAAAAASUVORK5CYII=

It depends on your data set and how you'd like your chart to display in considering whether you'll need to multiply by 100. The chart follows the underlying data, not the formatting, and it appears that 1 is the baseline here. If you want it to appear as 100 in your chart if that assumption is correct, then yes you'll need to multiply by creating a calculated field based off that data. Please let me know if you have any further questions.

Regards,

Mike

photo
photo
1

Hi Drew,

I just wanted to check in and see how things are going with this.

Regards,

Mike

photo
1

Hi Drew,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you yet, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike

photo
2

I have the same issue. I create a variable to chart by dividing one column by another. Then I format the result as a percentage and it looks good:

/4deb9dab8dfef44fa20275b22fa50463

Format as a Percentage:

/b2337f2209e5a4a0ad59153b56459c53

But then when I go to make it a chart, the y-axis is 0-1, the underlying number.

/77a006c56e5816a68f46e1ea6ec1187b

Am I reading this thread correctly that while the 0-1 can be formatted to 0-100% on the data view, to show it that way in a chart requires creating a new column that's multiplying it by 100? Or is there a simpler option?

photo
1

Hi Sam,

It displays this way because charts are generated based on what underlying data is. The Percentage Formatting is just formatting at the table level in Yellowfin.

You can do a couple things to override or change this. One, as you mentioned, is creating a Calculated Field to achieve the numeric result.

Another would be to instead use an Advanced Function. For example, here's a report with 3 columns:

/73c89e27922b5c5f492fe89b1caa6923

If I wanted to chance Invoice Estimate to a Percentage format, it would make 10,088,580, 1.08 billion, but the values would still show as they are here in the chart.

If I instead apply an Advanced Function > Percentage Against Column and choose against Invoiced Amount:

/619150735fbc7a1b7f1a83733258f439

It looks like this. I can of course edit the formatting further:

/c521aa6d2ee4cf2d5f1eda4f1080e495

/6aca75eef5cac59ed4400b0b1c0b0035

And now in my chart these are all percentages that align with what's in the table:

/5f8f64629c610bec213ea8e7ca700a99

Hopefully this makes sense, but please let me know if you have any further questions on this.

Regards,

Mike

photo
2

Thanks Mike. The Advanced Function -> Percentage Against Column approach looks good. Unfortunately I'm already using an Advanced Function, as my numerator column is an Accumulative Total, and I couldn't see a way to combine the two to make it accumulative and the percentage of another column. But I ended up creating a new column that multiplies by 100, and that got me the chart axis formatting I needed.

photo
1

Hi Sam,

Thanks for letting me know your solution! This considered, I'll go ahead and close this case out, but please don't hesitate to reach out with any other questions or concerns.

Regards,

Mike

photo
3

Not sure if I can use this post but have an issue with showing percentage in charts. How can I get the details on data points to show as percentage? My vertical axis shows correctly but when I hover over a data point the values are decimal still.

photo
1

Hi Frank,

Thanks for reaching out. The Tooltips follow the formatting in the Data section of the report builder, so if you had a '%' suffix there, it will show up in the Tooltip:

/4afbcfe03e799b6080796a86fe0f8a7c

/9ddc015a0005a9dd7ef7551c5bef7afd

/f2cd3e5b5a523e0b3c09cbd71fc24bd8

Please let me know if you have any other questions or concerns.

Regards,

Mike

photo
1

That was too easy. Appreciate the answer.


One last thing. Is it possible to sort the tool tip items in descending order by value?

photo
1

Hi Frank,

Much like the example above, where the Tooltip follows the formatting of the data, the Tool Tip list order will follow the Series order. I can't see much in your screenshot as it's focused on just the Tooltip portion and I can't see the rest of the Charts section (or Data section), but I suspect somewhere in your dataset there is an order that corresponds to Sys Admin, Scheduling, and Remote Support in that order. There's no explicit way to sort the Tooltip order on its own.

If you have any other questions on this though, please create a new ticket so we can best track these separate issues. Also, if you choose to do so, please be sure to include screenshots of the entire Charts and Data section so we can get a better sense of your overall setup.

Regards,

Mike

photo