20 Replies Latest reply: Aug 28, 2014 2:53 AM by Nikhil Garg RSS

    SetAnalysis

    Nikhil Garg

      Hello,

      I have a Disaster Data having following Dimensions:

       

      Disaster.Year , Disaster.Type , Disaster.Killed(Total Killed People for particular disaster) , StateData.Killed(Statewise killed people for particular disaster) , StateData.Location.

       

      I want to create a bar chart showing the total killed people for different disasters in increasing order. i.e Total killed people by disaster1 , then disaster2 and so on.

       

      I am using following set analysis but it is not giving me ryt output. Please solve the issue....

       

      Sum({$<Disaster.Type = {"=rank(Sum(Disaster.Killed),4)<= 10"} > }Disaster.Killed)