Forum Discussion
Need help finding the right function and syntax in PBI report
I have two tables (date, and issues table). The Date table has sequential dates for reference from 2016 to 2020 in order. My issues table has a list of work incidents, namely with a "closed date" and...
Hey MattAdams, can I inquire as the how you are expecting to visualize this? Is what you are trying to achieve that you could click an issue and then have a table of all of the dates that issue was open? Or are you trying to aggregate this in some way? Trying to understand the use case.
It will be shown with a area chart/graph, showing the count of open issues by day or week....This will ultimately show a trend when the count by time buckets (1-2 days, 2-5 days, etc) rise in count by day or week, or drop. This ultimately shows how much work we are getting done or not done. Does that help? Its basically to show aging work and how its getting done as days and weeks progress.