Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 291 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Dataset having single record but when added to dataflow shows inflated dollar value
Rupak C
Rank 3 - Community Apprentice
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.
1
Best Answer
-
Hi @Rupak C
did you applied any aggregation rule on that column , can you check and see if its fixes your issue.
Regards,
Arjun
0
