Has anyone faced this issue ?
We have data sets (Mode-Live) using LSQL and that does not have any duplicates, in this example we specifically added more filters to deal with one single record from the data set as source.
It has $8273
While adding the dataset to the dataflow, this also shows one record but with inflated value on the $ column - $256498.23 in this case, almost 30 times.
We added Group By and DISTINCT in the Dataset LSQL to try fix it, but still shows wrong inflated value.