Forum Discussion

tylerbauer's avatar
tylerbauer
Helper II
9 years ago

Summing data based on date

Hello, I have a table with values that I am trying to trying to create a summation for. I looked around the forum for this answer but I had difficulty finding it. 

 

For instance, if I have a table with these values I'd like to display the column "Sum" on my graph. 

DateDataSum
6-Jul1010
8-Jul1222
10-Jul1436

 

Need Help

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago
    tylerbauer wrote:

    Hello, I have a table with values that I am trying to trying to create a summation for. I looked around the forum for this answer but I had difficulty finding it. 

     

    For instance, if I have a table with these values I'd like to display the column "Sum" on my graph. 

    Date Data Sum
    6-Jul 10 10
    8-Jul 12 22
    10-Jul 14 36

     

    tylerbauer

    How would you like the column "Sum" displayed? Have you ever tried with any table or bar chart visual? Don't the visuals return the  summation of "Sum" column? Could you be more specific on the expected output?

    • tylerbauer's avatar
      tylerbauer
      Helper II
      9 years ago

      Hi Eric, 

       

      Thanks for your response. I am trying to display this as a line graph. I have 3 measures I have calculated as a summation of a field. Now, I want to produce a graph that summarizes those 3 measures. Currently, the graph displays the 3 measures going up and down but I want them to add on to each other. 

       

      Please let me know of any questions or concerns you may have.