Data option to show percentage value and percentage bar together

David Rue shared this question 13 days ago
Completed

Is there a way to show the percentage value (ie. 50%) in a cell of a report and also include a percentage bar? I hate to have 2 columns just so one shows the value and one shows the bar.

Replies (8)

photo
1

Hello David Rue,

My name is Yamini Naidu from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #33476
Case Title: Data option to show percentage value and percentage bar together

Please allow us some time to thoroughly assess the matter and provide you with a prompt response. Your patience is greatly appreciated.

If you have any additional information to share or need to provide further context, kindly reply to this email.

Sincerely,

Yamini Naidu

Yellowfin Technical Support Engineer


photo
1

Hello David Rue


With regard to your inquiry, I would like to share the following information.

Yes, you can use Conditional Formatting to display both the percentage value and a percentage bar in the same cell. Here's how you can do it:

  1. Right-click on the column heading where you want to apply the formatting.
  2. Hover over "Format" and select "Conditional Formatting."
  3. Choose "Basic" as the Alert Type, "Bar" as the Style, and "Percentage of Max" as the Type.
  4. Add rules to define the color and appearance of the bar based on the value.

This way, you can display both the percentage value and a visual bar in the same cell without needing two separate columns.

For more details, you can visit the official documentation here.


Please let me know if this meets your requirements or if you have any different needs. It would be helpful if you could share a snippet of the expected output for our reference, so we can review it and provide an accurate solution.



Thank you,

Yamini Naidu

Yellowfin Technical Support


photo
1

Please see video below for what I've done. I was able to get the conditional formatting to work, but not include both the value and the bar together in the same column.

https://www.loom.com/share/1ebcb8dc999c464eb933141bcf558a46

photo
1

Hello David Rue

Thank you for providing the video. It will greatly assist in accurately assessing the issue. Kindly allow me some time to review it, after which I will share an update with you

Regards,

Yamini Naidu

Yellowfin Technical Support

photo
1

Hello David Rue

I have tested the issue and shared the replication video in the link below. Please review the video—I hope it helps. Let me know if you have any further questions

https://ftp.yellowfin.bi/f/3ffdc9cdd1b40719

Thank you,

Yamini Naidu

Yellowfin Technical Support

photo
1

Hello David Rue,

I hope you are doing well

I wanted to follow up with you regarding the solution I provided in my last email. Did the solution we sent you resolve the issue?
Please let us know if you need additional support on this issue.

Thank you,

Yamini Naidu

Yellowfin Technical Support


photo
1

Yes

photo
1

Hello David Rue,

Thanks for your response

I am glad to hear the issue was resolved. If you have any other issue please contact us again by opening up a new ticket and we will provide additional support.

You will be receiving a Survey to evaluate our support, it would be very helpful for us if you could hit us with a SATISFIED on that Survey.

Thank you,

Yamini Naidu

Yellowfin Technical Support


Leave a Comment
 
Attach a file