Solved

Diff between Start Date and End Data

  • 23 November 2023
  • 4 replies
  • 73 views

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"}
icon

Best answer by Michael Ullock 12 December 2023, 22:01

View original

4 replies

Userlevel 2

Hi Marketa, 

thanks for sending this in and bringing this to our attention.

I was able to replicate this issue on my side and can confirm that this is not the expected behaviour. Therefore, I have gone ahead and created an internal ticket for our engineers to look into this issue and to get this fixed. Once I have more details on the fix for this issue, I will reach back out to you and let you know. Our sincere apologies for the troubles here in the meantime. 

Thank you! Marketa

Userlevel 2

Hi Marketa, 

my apologies for the delay in getting back to you - but I am happy to report that the fix for this issue has already been rolled out. 

Can you please verify this on your side and let us know if you're running into any further issues? 

 

Dear Michael, all is working on my site :) I changed type of relationship into M:N and that helped :) Marketa

Reply