Sum after a Year Chart Cumulative

[Anonymous]

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 value after year 2022 shows the count of everything after that

[TheoC · Accepted solution]

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 🙂