Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking to get a total value of courses completed on time in a KPI chart..
To get this, I think I need a IF MATCH statement.
Basically, if the (course end date) matches the (course estimated end date) then I would then want the number to show in the KPI so the code will go in the KPI chart
Hope this makes some sense
Thank you
I think the better way is to create an indicator in the script like below -
If([Course End Date] = [Course Estimated end date] = 1,0) AS [On Time Indicator]
and then in the chart, you can do something like this -
Count({<[On Time Indicator] = {1}>} [Course ID])
Just an idea, your data model might need a tweak to make it work
I think the better way is to create an indicator in the script like below -
If([Course End Date] = [Course Estimated end date] = 1,0) AS [On Time Indicator]
and then in the chart, you can do something like this -
Count({<[On Time Indicator] = {1}>} [Course ID])
Just an idea, your data model might need a tweak to make it work
Try
=Count({$<RecordID={"=EndDate =EstimatedEndDate"}>}DISTINCT CourseID)
RecordID is unique for each row in the table
This worked! Thank you 🙂