Forum Discussion
bgashok
Helper I
Helper Icreate graph from daily data of dataset
I have below two table form Azure and would like to plot two graph. Graph 1 = Y-axis : No. of work items in close state from the items present at start of sprint date / total no of work items pre...
lbendlin
Super User
Super Usersee attached
bgashokHelper I
Helper Iit's not giving expected results, I want to share pbix file, but unble to upload it here.
Shall I share the table data here. it around 9K records?
- lbendlin
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.- bgashok
for Q2-S7 sprint start date is 25 Oct and end date is 7 nov.
on 25 oct:
Team Sprint Work Item Id State Closed Date Date Team Y Q3-S1 76 Ready null 10/25/2023 Team Y Q3-S1 51 New null 10/25/2023 on 7 Nov:
Team Sprint Work Item Id State Closed Date Date Team Y Q3-S1 76 Closed 2023-11-07T11:17:30.9030000-06:00 11/7/2023 Team Y Q3-S1 89 Closed 2023-11-07T11:17:30.9030000-06:00 11/7/2023 Team Y Q3-S2 89 Ready null 11/7/2023 Graph 1 = Y-axis : No. of work items in close state from the items present at start of sprint date (1 )/ total no of work items present at start of sprint date (2 - ignore if any closed task is presnt in count). X-axis : Sprint name
= 1/2*100 = 50%