Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I would like to set a condition for KPI. So, the problem is I have two columns consist of two dates. These dates refer to planned date and execution date. I would like to count how many item that has different dates and show the total of these items with KPI. What expression that I could use to do this condition? Thank you.
Hi,
could be something like this, to count how many days you have in your column DATE that are different from Date 1 and Date 2.
=Count({<DATE=-{"$(=Date2)","$(=Date1)"}>} distinct DATE)