1 Reply Latest reply on Feb 8, 2018 9:12 AM by Varun P

    Trend chart - require date calculations

    Varun P

      I have dimension as date,  --(Date has discrete dates- some dates from this months , 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.

       
      below data gets refreshed everyday.

       

       

      dateTeam nameTeam IDResult
      24/07/2008lol458pass
      27/01/2017pop1478fail
      28/02/2018laugh99pass
      and so on

      can i create trend chart with this data ?

       

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

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

       

      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}

       

      Please help with calculated filed calculations

        • 1. Re: Trend chart - require date calculations
          Varun P

          I have got how to find last day of month :  

          below formula identifies the last day of every month:

          DATEADD(‘day’,-1,DATEADD(‘month’,1,DATETRUNC(‘month’,[Date])))

          1} Can anyone explain what exactly each above words in formula do/ functions ?
          2} by using above can anyone help me with my original query?
          Thanks !