Tooltip showing 'blank' week commencing date for some weeks

[jenniferrosemitchell21]

Hi Nick, Just noticed that the tooltip for throughput. quality and sustainability graphs is missing the dates from the last few weeks.

• This is your latest Dec 5th template version.
• I have no filters applied
• I've checked the dates table and it runs to 2024 end
• I've checked the tooltip sheets and they seem fine

[nbrown02]

Sorry not seeing it on any reports my end - does it happen if you refresh?

[jenniferrosemitchell21]

Hi Nick,
I've set the reports to automatically refresh on a daily basis, but have just refreshed it now and unfortunately still getting blanks. Weirdly the blanks seem to vary depending on the Team filter. Is there anything I can check on my end?

[nbrown02]

The only other thing to check would be making sure no relationships have been created between tables incorrectly - I've just reviewed all the reports I use currently and published new ones to the service and still not seeing this issue on any of the reports :/

…

On Tue, Jan 9, 2024 at 7:51 PM jenniferrosemitchell21 < ***@***.***> wrote: Hi Nick, I've set the reports to automatically refresh on a daily basis, but have just refreshed it now and unfortunately still getting blanks. Weirdly the blanks seem to vary depending on the Team filter. Is there anything I can check on my end? image.png (view on web) <https://github.com/nbrown02/FlowViz/assets/134519976/cda374db-1e5f-4cf0-86be-efe7b9ae627e> — Reply to this email directly, view it on GitHub <#114 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AHACM2UFW6CLG2HHPD6LWFLYNWNURAVCNFSM6AAAAABBS4FWUOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOBTGY4DGOJXGI> . You are receiving this because you commented.Message ID: ***@***.***>

[jenniferrosemitchell21]

Hi Nick, I have 3 reports with no additional relationships and one were I have created 2 extra relationships in order to get a Work Item Type filter. For the 3 reports with no changes made, at the top level dates are there in the tooltip. But when filtering by Team the tooltip disappears. If there is anything else I can try, let me know. If there's nothing that can be done that's fine - please close the ticket and I thank you for your wonderful template! :D

[nbrown02]

Got to the bottom of this after going back through a few years' worth of templates. It seems over the years that one relationship has changed in its filtering, instead of being set to 'both' it should be 'single':

When changing this it fixes it for me

[jenniferrosemitchell21]

Hi Nick, Thank you very much indeed!! Really appreciate it. I will change that now.

[nbrown02]

Closing as now resolved :)