How do we limit groups in a chart?
We would like to create a small and simple chart that shows the total amount of orders processed for the past 5 days. We are able to create the chart to populate the necessary information, however, we want to limit the chart x axis group(OrderDate) to show only 5 days. For example, we only want 5 bars on the chart and not to exceed 5.
Currently when there are more than 5 days with orders processed, the chart keeps expanding to show all the orders processed for all of the days. How do we tell this chart to only show the last 5 days worth of processed order(today, and the past 4 day)?
Thank you all in advance for your help!