Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have the following expressions with set analysis:
To count the number of observations:
COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"},OBSERVATIONS={">0"}>} OBSERVATIONS)
To count the number of anomalies:
COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ANOMALY_ID)
Now I need to count the number of observations with anomalies, using both expressions.
Do you know how could I do that?
Thank you!!!
Try this
COUNT ({$<ANOMALY_ID=P({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} ANOMALY_ID),ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"},OBSERVATIONS={">0"}>} OBSERVATIONS)