Count No of days based on 2 dimension

0 votes

Dear Community members,

I need help to find no . of days.

I have field Customer Name,Date and Sales

I have tried LOD expression:

{include [Customer Name],[Date]:IF (SUM([Sales]))>=1 THEN 1 END}

May 24, 2020 in Tableau by Ravi
• 120 points
207 views

1 answer to this question.

0 votes
answered May 26, 2020 by Gitika
• 65,870 points

Related Questions In Tableau

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
14,706 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 11, 2018 in Tableau by QueenBee
• 1,820 points
122 views
0 votes
1 answer

Filter Measure Based on Different Variables of the Same Dimension

Hi Nithin, I used calculated fields. You can use ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 32,930 points
168 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
6,802 views
0 votes
1 answer

How to display days data based on date selected in the filter by the user.

You can create a parameter for dates. Select data ...READ MORE

answered Aug 14, 2018 in Tableau by AwesomeSauce
• 860 points
544 views
0 votes
0 answers

Dynamically set the value of a filter based on a parameter selection in use to swap sheets

So I created a parameter to swap ...READ MORE

May 20, 2020 in Tableau by Patrick
• 120 points

edited May 20, 2020 by Gitika 615 views
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
1,487 views
0 votes
1 answer

Is it possible to join tables on the basis of some calculated field in Tableau?

@Ammy999, You can not perform join in ...READ MORE

answered May 16, 2018 in Tableau by Mathew1810
526 views
+1 vote
4 answers

Show 0 if value has no data - Tableau

Hi Abhay, To replace null or empty values ...READ MORE

answered Apr 24, 2019 in Tableau by Cherukuri
• 32,930 points
48,539 views