Hello, I'm writing an app that will pull some agile development metrics from a SQL Server and display them. Ideally, I would like to build in the ability to add metrics through the app.
My data set in SQL Server has a row per week. Each row has the year, month, and a date that represents the cut-off date for measuring the statistics that week. I've built the app so you can choose a month and a year from drop down boxes, then another drop down will populate with the individual weeks from that year/month combo to view stats. I'm good up to this part.
What I'd like to do next is to display the statistics for the week that a person chooses. I'm using text boxes for this but am open to suggestion because I suspect this is not the best approach. Right now I accomplish this by using this code for the Default property of my text box:
First(Filter('[test].[Team_Health_Velocity]', DateValue(WeekEndingDate.Selected.Value) = WeekEndDate)).Velocity
In short, taking the date value the user selects from the drop down, finding the row in the database that corresponds to that date, then pulling back the Velocity metric. No warnings or errors, but no values being populated.
Picture attached to better illustrate what I'm up to:
