1 Reply Latest reply on Aug 27, 2018 9:47 AM by Jim Dehner

    Pre and Post event analysis when we are using blending options

    yamuna.kosireddi

      Hi Community,

       

      I am trying to achieve pre and post event analysis for selected event from the parameter.

       

      I have achieved this when data sets are in JOIN condition due to some data issues .Now we are connecting separately and using blending

       

       

      Below is the calculated field i have written and i was working fine if is in Join condition.Can any one tell me how do i change the formula:

       

      MONTH([Accident Date])={ FIXED MONTH([Accident Date]),YEAR([Accident Date]):max(if [Special Event Name1]=[Select Special Event] then MONTH([Accident Date]) END )}

      and

      YEAR([Accident Date])={ FIXED MONTH([Accident Date]),YEAR([Accident Date]):max(if [Special Event Name1]=[Select Special Event] then YEAR([Accident Date]) END )}

       

      Bolded one is the dimenion name from secondary data source..  how do i recalculated the formula

       

      Thanks