Set analysis for date does not work

mtabernad — Sat, 16 Nov 2024 17:56:02 GMT

Hi community,

I have this table:

I want to calculate the sum of numattacks where id_threat_type = 5 and date = 2020-10-16. The result should be 194, but it shows 0:

I think it could be a date format problem. In the script date variables are like this (D/M/YYYY):

But when date field shows up in a table its format is 'YYYY-M-D' as you. can see in previous captures. I do not know how. to solve it.

Thank you in advance!

Re: Set analysis for date does not work

Anil_Babu_Samineni — Thu, 22 Oct 2020 11:05:49 GMT

I can see you've missed {} for date like how you've done for {'5'}?

And this is not recommended rather try this way for date {"$(=Date(MakeDate(2020, 10,16), 'YYYY-MM-DD'))"}