Formula for percentage from categorical data

Livia shared this question 32 days ago
Answered

Hello YF and YF community,

I might just be having trouble finding what I need.

But is it possible to create a text box which shows the percentage of categorical data.

For example if I am measuring colours of cars, which is coded as (Red, Blue, Yellow)

Is there a formula that would add up all the Red cars as a percentage of the whole? Eg 27% of cars are Red.


Thank you in advance,

Livia

Replies (3)

photo
1

Hi Livia,

Thanks for reaching out to support. It appears your account is new here; we have a good supply of educational offerings through the Yellowfin University, along with personalized content creation assistance available through our consulting partners as per contract, highly encourage speaking to an account manager about the best ways to utilize these.

https://university.yellowfinbi.com/collections/technical-training


Sounds like you may have luck using an advanced function to achieve this.


c42e6fd10c27914c73c5b3ef01f245c5


https://wiki.yellowfinbi.com/display/yfcurrent/Advanced+Function+Basics

The wiki is another good source of information on practical Yellowfin setups, the Ski Team tutorial content available on install also includes a number of useful examples for context. Hope this is helpful, let me know if you need anything additionally.

Thanks,
Eric

photo
1

Hi Livia,

Just wanted to check in to see if you had a chance to review my reply at this time.

Thanks,

Eric

photo
1

Hi Livia,

I'm going to go ahead and mark this question as Answered due to inactivity at this time. Feel welcome to reach out in the future.

Thanks,

Eric

Leave a Comment
 
Attach a file