0 votes
1 view
in BI by (13.2k points)

I have dimension as date, --(Date has discrete dates- some dates from this month, some dates from last and so on - with data.) more dimensions are: Team name & Team ID other dimension is Result. Result column has value: pass or fail ---only two values.

The below data gets refreshed every day.

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 the x-axis, Result: Pass or Fail on trend-lines. what would be my Y-axis?

Want to show pass or fail team ID wise on-trend lines!

If its December month then team ID which has passed /failed for 31st of December 2017 should show up. similarly for Jan month (team ID ) which has 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}

please help with calculated field calculations 

1 Answer

0 votes
by (36.4k points)

Do the following code:

if Date= today() then 1

elseif dateadd('day',-

day(DATEADD('month',1,Date)),DATEADD('month',1,Date))=Date then 1

else 0

than set filter to 1

...