Forum Discussion
Helper IIICreate formula depending on 3 column and display in one Stack bar
Hello
I have one table which is contaning 3 columns i.e. HD (Yes/No), PD (Yes/No), Status (Approved, BP, Off). I want to display 5 bars in One Stack Bar. I crated following formulas deoending different conditions. How can I achive this.
HDCount = TotalYes/total count If HD = "Yes" && Status="Approved"
PDCount = TotalYes/total count If PD = "Yes" && Status="Approved"
HDPDCount = Total Yes/Total count if HD = "Yes" && PD = "Yes"
HDBPCount = Total Yes/Total Count If HD = "Yes" && Status="BP
PDOffCount = Total Yes/Total Count if PD = "Yes" && Status ="Off"
Thanks
Avi
Hi avi081265 ,
You may try other visual objects for the purpose like this:
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
avi081265Can anyone help on above requirement
Hi avi081265 ,
Based on your description, I created the simple sample, you may check the result:
Please feel free to correct me and provide more information if I have misunderstood you!
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- avi081265
Thanks or solution. Is there aany way we can display count on each bar?
Hi avi081265 ,
You may try other visual objects for the purpose like this:
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.