Tableau Trend Line with Date Field Calculation

0 votes

Sample Dataset: gets refreshed everyday.

date      Team name Team ID Result
24/07/2008  lol      458    pass
27/01/2017  pop     1478    fail
28/02/2018  laugh     99    pass
and so on

I want to show dates on x axis and ​Result : Pass or Fail on trend-lines 

So what would be my Y axis?

I want to show the pass or fail- team ID wise on trend lines!

For example, 

If its December month then team ID which have passed /failed for 31st of December 2017 should show up. similarly for Jan month (team ID ) which have passed or failed should show of 31st jan 2018. AND for Feb month it should show pass / fail for current date --- {Team count pass or fail for particular current day}

Can someone please help with calculated filed calculations?

Aug 25, 2018 in Tableau by ghost
• 1,790 points
1,278 views

1 answer to this question.

0 votes

Try This:

if Date= today() then 1
elseif dateadd('day',-
day(DATEADD('month',1,Date)),DATEADD('month',1,Date))=Date then 1
else 0

then set filter to 1

answered Aug 25, 2018 by ffdfd
• 5,550 points

Related Questions In Tableau

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,163 views
0 votes
1 answer

Tableau charts with calculated field

I could get Visitor Rate = COUNTD(Visitor ...READ MORE

answered Jul 19, 2018 in Tableau by Atul
• 10,240 points
499 views
0 votes
1 answer

How to perform a calculation using one variable with an aggregation in calculated field?

Hi, You can use the calculative field and ...READ MORE

answered May 20, 2019 in Tableau by anonymous
• 33,030 points
464 views
0 votes
1 answer

How to replace the count(field) which is missing in data with zero in tableau?

Use calculated field to create a dummy ...READ MORE

answered Dec 21, 2019 in Tableau by sindhu
1,797 views
0 votes
1 answer
0 votes
1 answer

Executing IF-THEN_ELSE before Executing Calculation - Tableau

You can use a combination of a ...READ MORE

answered Sep 29, 2018 in Tableau by ghost
• 1,790 points
701 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,393 views
+2 votes
1 answer
0 votes
1 answer

Error: Comaparing date value with YEAR in Tableau

You have to ensure that the comparisons ...READ MORE

answered Jul 11, 2018 in Tableau by ffdfd
• 5,550 points
431 views
+2 votes
1 answer
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