Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sum after a Year Chart Cumulative

hello im want to know if is possible get soem values summarized after certain time for example i want to know the qty of sites after 2022 all this in the chart  like in here instead of put any...
Need Help
Tutorial Requests
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Anonymous 

     

    You can do a couple of things. One quick way is to create a Calculated Column like below:

     

    Then in the Fields pane (far right of screen), click the "Year" column and the "..." button. Go to "New Group" then in Group Type change "Bin" to "List".  From the list, select the historical and current year (i.e. 2019 to 2021) and use the "Other" group to include "ungrouped values". Click Okay.

    You can now use the "Year (groups)" field for your X axis.

    Hope this helps 🙂

TheoC's avatar
TheoC
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

 

You can do a couple of things. One quick way is to create a Calculated Column like below:

 

Then in the Fields pane (far right of screen), click the "Year" column and the "..." button. Go to "New Group" then in Group Type change "Bin" to "List".  From the list, select the historical and current year (i.e. 2019 to 2021) and use the "Other" group to include "ungrouped values". Click Okay.

You can now use the "Year (groups)" field for your X axis.

Hope this helps 🙂