R12.2.10 | V6 | Bar Chart is not showing right value as compare to data in the table
This is custom made dataset of Inventory transaction, ECC_SPEC_ID is transaction_id, view name: xxecc_inv_trxn_vw
req: To find number of transaction day wise.
Solution: Create a bar chart, Dimension - "Transaction Date", Metric: Count - distinct Transaction_id
Data verification:
Select distinct transaction_id from xxecc_inv_trxn_vw a where a.ORGANIZATION_CODE='IFS' and trunc(TRANSACTION_DATE)='31-JAN-2021';
rows count: 1225
Where as the bar chart is sowing 161 ,
What could the reason ?
Tagged:
0