Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Members,
i have the following problem:
I would like to calculate the differences (in days) between two dates witth set expression, like here:
SLA Statuswechsel with SLA Status 'Technical Complete' - SLA Statuswechsel with SLA Status 'Open'
Following necessary information:
SLA Statuswechsel = Date Field (includes the date in following format: DD.MM.YYYY)
SLA Status: Includes different Status (Open, In Progress, Technical Complete, Close).
Can anyone help me???
Thanks and regards
Josh
Try this:
fAbs(Only({<Status={'Technical Complete'}>} [SLA Statuswechsel]) - Only({<Status={'Open'}>} [SLA Statuswechsel]))
Try this:
fAbs(Only({<Status={'Technical Complete'}>} [SLA Statuswechsel]) - Only({<Status={'Open'}>} [SLA Statuswechsel]))
Hey thanks but the solution doesn't work for me. I would like to use this formula in a KPI diagram where you can just use measures and not dimensions...
Hey both solutions works in a table but not in a measure KPI field. Do you have any explanation?
Does this function works with AVG too?
You can use most aggregation functions (min, max, sum, avg, ...) instead of Only().