Count of Id within another Id

0 votes
Hi, i need help getting count of Id within another Id field.Order ID has cashier id in it. Can you find the count of those orders for each cashier?
Apr 10, 2019 in Tableau by Kalyan
1,068 views

1 answer to this question.

0 votes
Hi Kalyan,

If you have exact cashier id to check with then, follow any below step:

1. Split the field into parts and then create a field with sub string of that. Now put the field in filter shelf and drop count of order in text field to show count of these orders.

2. Use contains() field to check if order id contain cashier id, and then form a group. Now perform count aggregation on the field to get the count of orders.

Hope this helps you.
answered Apr 10, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
3,069 views
0 votes
1 answer

How to use LOD to count distinct number of records based on some condition?

From the desired output it seems that ...READ MORE

answered Apr 9, 2018 in Tableau by xyz
• 1,560 points
17,324 views
0 votes
0 answers

How can I sort date field in presence of another date field in Tableau?

Goal: Sort the new ship date in ...READ MORE

Apr 10, 2018 in Tableau by ghost
• 1,790 points
1,352 views
0 votes
1 answer

Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

answered Apr 12, 2018 in Tableau by QueenBee
• 1,820 points
1,029 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,832 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,561 views
+2 votes
1 answer
0 votes
1 answer

How to aggregate and count the occurrence of TRUE and FALSE?

Hi, you can do any of below ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
2,903 views
0 votes
1 answer

How to show a chart within another chart.

Hi Anitha, Yes, it is possible to show ...READ MORE

answered Mar 29, 2019 in Tableau by Cherukuri
• 33,030 points
595 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP