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?