Hi, I am trying to do a diff between end and start date, I am trying this formula in metric: SELECT SUM(SELECT DATETIME_DIFF({label/startdate2.day}, {label/enddate2.day}) BY {dataset/flights}), and it doesnt show any error, but when I am trying to visualize, I am getting error trace: d9781182e7f70bd623d858893b240c73
{ "title": "Bad Request", "status": 400, "detail": "A result cache error has occurred during the calculation of the result", "resultId": "db07993fb7512eae09bf975606466e10c948704c", "reason": "General error", "traceId": "d9781182e7f70bd623d858893b240c73"}
Best answer by Michael Ullock
View original