I have two charts both with the same problem. When I make a bar chart with the X axis being dates grouped by weeks and the Y axis being a count of those items I get bars for each week. However when I click a bar to get a drill-down I’m only getting dates from the previous week. So if I have this:
Week 1 - July 8 - 3 items
Week 2 - July 15 - 1 item
Week 3 - July 22 - 7 items
If I click week 3 (July 22) the drill-down only shows 1 item that has a date of July 12, so it’s the week before.
This is real problem as my chart based off of due dates I have to click the week ahead to get the right data. My chart based on completed dates is even worse as I can’t see the current week’s completed items at all. Attached screenshot shows the discrepancy
You example is not aligning with what the screen shot shows. You have mentioned
Week 1 - July 8 - 3 items
Week 2 - July 15 - 1 item
Week 3 - July 22 - 7 items
but in the image its in the following format
Week 1 - July 8 - 4 items
Week 2 - July 15 - 1 item
Week 3 - July 22 - 4 items
It will be great if you ask out your query with more clearity
Apologies, the dates/items I listed were just used an example and not from the screenshot. Using example from the highlighted:
Week 1 - July 29 - 15 items
Week 2 - Aug 5 - 8 items
Week 3 - Aug 12 - 3 items
I click Week 3 (Aug 12) expecting 3 items items to be shown with completed date ranges of 8/12-8/19. Instead I’m shown 8 items with date ranges from 8/5-8/12
