Dataset having single record but when added to dataflow shows inflated dollar value

Rupak C

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.

Mallikarjuna Kuppauru-Oracle

Hi @Rupak C

did you applied any aggregation rule on that column , can you check and see if its fixes your issue.

Regards,

Arjun