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
242 views

1 answer to this question.

0 votes
answered May 26, 2020 by Gitika
• 65,950 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
15,355 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
178 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
• 33,010 points
213 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,230 points
7,442 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 15, 2018 in Tableau by AwesomeSauce
• 860 points
657 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 818 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,230 points
1,717 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 17, 2018 in Tableau by Mathew1810
652 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
• 33,010 points
66,203 views