Forum Discussion

drrai66's avatar
drrai66
Resolver I
8 years ago
Solved

Running SUM (LINE CHART)- Help Please

Hi Experts, How I can Create a Running SUM LINE Chart with Week Number on X AXIS and Value on Y AXIS with Following Data. I Need a Formula which I can apply to my Similar Big Data set.  Thanks in A...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi drrai66,

     

    My solution does exactly that.  What problem are you facing when downloading my file?

drrai66's avatar
drrai66
Resolver I
8 years ago

Hi Ashish,

Actually, I could not access your Solution. Can you provide the formula. As you can see in the following view, I have the weekly values per week in Line graph, so now I want to accumulate them  the way you showed me in previous reply. so that values get added up and I get an Increasing Trend.  I have got these values by COUNTING and not SUMMING. I have to do COUNTING to get these values per week and then do a Running sum of them.

Thanks for Help again

Deepak

This is what I have

But I need above chart to be like this which I have in Tableau

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi drrai66,

 

My solution does exactly that.  What problem are you facing when downloading my file?

  • drrai66's avatar
    drrai66
    Resolver I
    8 years ago

    Hi Ashish,

    Got it finally...

    Thanks a lot

    Deepak

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      You are welcome.

  • sevenhills's avatar
    sevenhills
    Super User
    8 years ago

    Hi Ashish

     

    For some reasons when we click the link first time it wont work (in chrome) ... Again you click the same link it works ... I tested twice by closing chrome browser and reclicked the link ...

    just FYI. Not that your file is problem, the download link wont show up first time and refresh or clicking the same link it shows :-)

     

    Thanks