sdmx-twg / vtl

This repository is used for maintaining the SDMX-VTL specification
11 stars 7 forks source link

Wrong example in the documentation for use of count in a having clause #457

Open jmsimonma-md opened 5 months ago

jmsimonma-md commented 5 months ago

In the aggregation operators in the count part we have the following example (Example 2) DS_r := sum ( DS_1 group by Id_1 having count() > 2 ) and I think it is wrong for the input data provided in the example. We can change the expression DS_r := count( DS_1 group by Id_1 having count() > 2 ) Or if we want to keep the original expression, we have to provide a input with a numeric measure and the result datastructure must contain the grouped identifiers and the measure, not Int_var.

javihern98 commented 4 months ago

Suggestion: giving the fact that the result has int_var, we should change only the expression;

image