4 Replies Latest reply on Mar 17, 2016 12:13 AM by Nagaraju ponugoti

# How to calculate the count in the table

Hello Tableau Experts ,

Can you please Help me out on this

My Input is like below  and my input data source i attached below please find it

Comment
Type
Nsc
-----------------
---------------------------
-----------------------------

My out put would be below table ( here i am calculating the Type ="complaint" where NSC is main dimension and all the K9K_DD ,K9K_MOBILITY , ETC...........WOULD TAKE OUT FROM COMMENT FIELD BUT HOW COULD WE ACHIEVE THIS I HAVE USED SETS AND GROUPS BUT I AM NOT GETTING THIS OUTPUT PLEASE THIS IS THE CHALLENGING OUTPUT FOR ME PLEASE HELP ME OUT ASAP AND GIVE ME THE PROPER NAVIGATION

• ###### 1. Re: How to calculate the count in the table

Maybe this approach works?

[Comment Group]

if contains(upper([Comment]),"K9K_MOBILITY") then "K9K_MOBILITY"

elseif contains(upper([Comment]),"K9K_WARRANTY") then "K9K_WARRANTY"

elseif contains(upper([Comment]),"K9K_COST") then "K9K_COST"

elseif contains(upper([Comment]),"K9K_DD") then "K9K_DD"

else "Other"

END

You can add other category like "PIPE" with analyzing comments in detail.

Thanks,

Shin

9.0 attached

1 of 1 people found this helpful
• ###### 2. Re: How to calculate the count in the table

Thanx a lot for your valuable reply it is perfectly working

• ###### 3. Re: How to calculate the count in the table

Happy to hear so.

BTW, could you mark the answer correct for other people to understand it's answered.

Thanks,

Shin

• ###### 4. Re: How to calculate the count in the table

HI Shini

Thanks a lot for your contribution for my queries

actually i am new to tableau i am trying to enhancing my skills in tableau

but i know all the basics how to create the charts and dashboards and also analysis part

but when it will come to write a functions i am not getting proper examples can you please tell me the proper guide for this or else any documents if you have try to share with me it would be great help full to my career

Thanks

Nag