have a data set that reports on the number of claims made in a certain area. the raw data contains a posting date per claim. in a calculated field, this is used to create a weekending date field. our weekending day is always friday, so a weekending date of 23 July 2020 will have a weekending date of Friday, 24 July 2020. Ultimately, i am trying to produce a bar chart with number of claims by weekending date. so, for Axis, i have Claim Week ending (which is the calculated field) and values as Number of Claims. instead of using the Friday date specified in the Claim Week ending field, the data is shown with a Sunday weekending date. so, for that week mentioned above, the weekending 24 July is shown with the correct count but with the date 26 July as the Label for the x- axis.
If i right click on the label, and Show as table, i get a table with the correct Friday weekending dates. I am perplexed. How do i get these labels to display correctly?
If i right click on the label, and Show as table, i get a table with the correct Friday weekending dates. I am perplexed. How do i get these labels to display correctly?
