Forum Discussion
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 value after year 2022 shows the count of everything after that
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 🙂
1 Reply
- TheoC
Community Champion
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 🙂