6 Replies Latest reply on Feb 9, 2019 1:43 PM by Eric Liu

    How to calculate on selected month across years

    Eric Liu

      Hi everyone,

       

      I tried to sum the value on selected month across years and show the result in bar chart, but the result is not I want. Can anyone help me? Thank you.

      Here is my problem: I created a calculation field to filter out some value that I need, and I want to sum them and show in a bar chat, but after I use bar chart, it will give me the total value from December, not the sum of value that I selected by using calculation field.

       

      Here are the number that I want to sum:

      Screen Shot 2019-02-08 at 23.45.28 PM.png

       

      The calculation field that I use:

      Screen Shot 2019-02-08 at 23.46.38 PM.png

       

      But after I use bar chart, it will show me the total value from December not the sum of what I selected:

      The number that I want should be 0.5107 instead of 0.4852.

       

      Screen Shot 2019-02-09 at 00.06.09 AM.png

       

      Any way can figure this out? Thank you.