How to compute the delay between 2 columns containing dates #166
-
Hello We have just installed "Enhanced Table" and "Document Table" compatible version Kibana 7.10. I want to calculate the delay between 2 'date type' columns, which are in columns 2 ('SBB Date') and 3 ('PDP Date'). I also try to use parseDate(col2) - parseDate(col3), I have the error : Do you have an idea of the problem? Best regards. |
Beta Was this translation helpful? Give feedback.
Replies: 5 comments
-
Hi, First, to compute the delay between 2 dates, you do the right formula: Hope it will fix your issue, |
Beta Was this translation helpful? Give feedback.
-
Hi Fabien,
In fact, we have installed the v1.10.1 version.
I understand from the info on the Release page that the parseDate function and the timeRange variable only work from version v1.11.0 onwards, so I ask our installer to upgrade your plug-in to v1.11.0.
et merci pour votre réactivité ☺
Cordialement
Martine Leprince.
De : Fabien Baligand [mailto:[email protected]]
Envoyé : mardi 5 janvier 2021 01:29
À : fbaligand/kibana-enhanced-table <[email protected]>
Cc : LEPRINCE Martine <[email protected]>; Author <[email protected]>
Objet : Re: [fbaligand/kibana-enhanced-table] How to compute the delay between 2 columns containing dates (#166)
Hi,
First, to compute the delay between 2 dates, you do the right formula: parseDate(col2) - parseDate(col3)
Then I reproduced your issue, when upgrading enhanced-table v1.10.1 to v1.11.0.
And I fixed the issue, by totally removing browser cache.
I don't mean "Shift+F5" or "Ctrl+F5", but total cache removal in browser.
Hope it will fix your issue,
Et bonne nuit :)
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#166 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AO6KRWA3H7JXFQRPSYPNNJLSYJMNZANCNFSM4VS6MHEQ>.
|
Beta Was this translation helpful? Give feedback.
-
Hi Fabien
We have installed to new version v1.11.0.
Firsts tests are OK.
Thank you very very much ☺.
De : LEPRINCE Martine
Envoyé : mardi 5 janvier 2021 09:26
À : 'fbaligand/kibana-enhanced-table' <[email protected]>
Objet : RE: [fbaligand/kibana-enhanced-table] How to compute the delay between 2 columns containing dates (#166)
Hi Fabien,
In fact, we have installed the v1.10.1 version.
I understand from the info on the Release page that the parseDate function and the timeRange variable only work from version v1.11.0 onwards, so I ask our installer to upgrade your plug-in to v1.11.0.
et merci pour votre réactivité ☺
Cordialement
Martine Leprince.
De : Fabien Baligand [mailto:[email protected]]
Envoyé : mardi 5 janvier 2021 01:29
À : fbaligand/kibana-enhanced-table <[email protected]<mailto:[email protected]>>
Cc : LEPRINCE Martine <[email protected]<mailto:[email protected]>>; Author <[email protected]<mailto:[email protected]>>
Objet : Re: [fbaligand/kibana-enhanced-table] How to compute the delay between 2 columns containing dates (#166)
Hi,
First, to compute the delay between 2 dates, you do the right formula: parseDate(col2) - parseDate(col3)
Then I reproduced your issue, when upgrading enhanced-table v1.10.1 to v1.11.0.
And I fixed the issue, by totally removing browser cache.
I don't mean "Shift+F5" or "Ctrl+F5", but total cache removal in browser.
Hope it will fix your issue,
Et bonne nuit :)
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub<#166 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AO6KRWA3H7JXFQRPSYPNNJLSYJMNZANCNFSM4VS6MHEQ>.
|
Beta Was this translation helpful? Give feedback.
Hi,
First, to compute the delay between 2 dates, you do the right formula:
parseDate(col2) - parseDate(col3)
Then I reproduced your issue, when upgrading enhanced-table v1.10.1 to v1.11.0.
And I fixed the issue, by totally removing browser cache.
I don't mean "Shift+F5" or "Ctrl+F5", but total cache removal in browser.
Hope it will fix your issue,
Et bonne nuit :)