LinkedIn
Twitter
Hello,
I have a google sheet in which I have a table like this
| Key | created Date | Résolution Date | Priority |
| 1 | 18/12/2023 02:34:24 | 04/09/2024 07:31:00 | Nice to have |
| 2 | 29/03/2024 08:06:46 | 10/04/2024 07:16:00 | Current |
| 3 | 20/03/2024 05:59:12 | 10/04/2024 07:16:00 | Current |
On Looker Studio, I would hive the average time to resolution by priority :
(resolutiondate - created date) / Number of Key
I use datediff
but the result is false :
For Nice to have, the result must be 260 and not 275
For current, the result must be 16 and not 62
So, i don't undertand the difference and maybe my configuration is false.
Who can help me please ?
