6 Replies Latest reply on Feb 20, 2017 9:18 PM by Shinichiro Murakami

    Need help with level of detail and stack bar chart

    Manoj Ramachandra

      Hi have requirement to get number of calls that are above 7 day average for each ACTIVITY and for DATE selected. below is how the data set looks like. count(ucid) is considered as number of calls.

       

       

      I have calculated 7 day average for each activity as below. 7 day Avg calculation is sum of duration for last 7 days / total number of calls for last 7 days(do not compare avg against sample data set since it is dummy one)

       

       

      Now I need a stacked bar chart with activity in x axis(for any chosen DATE), The stacks(categories) I need are:

      1. Number of calls where call duration was > 7 day Avg

      2. Number of calls where call duration was <= 7 day avg

       

      Please help me to arrive with this solution.