Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Greetings to All
How i can show balance column in line diagram. I need to present daily balance but if i have more than one entry in same date then my chart result will be wrong. How i can solve this and which function can use for this situation.
Dimension: Date & Measures: Balance.
Date | Chq. No. | Debit | Credit | Balance |
1-Apr-20 | 176837.02 | |||
1-Apr-20 | 44 | 15,950.00 | 160,887.02 | |
5-Apr-20 | 675 | 20,000.00 | 140,887.02 | |
2-Jun-20 | 6754 | 31,500.00 | 109,387.02 | |
2-Jun-20 | 980 | 25,000.00 | 134,387.02 | |
13-Jun-20 | 1014 | 200,000.00 | (65,612.98) | |
13-Jun-20 | 100072 | 3,500.00 | (62,112.98) | |
10-Aug-20 | 778 | 3,600.00 | (65,712.98) | |
10-Aug-20 | 1041 | 670,000.00 | (735,712.98) | |
30-Oct-20 | 399 | 56,260.00 | (791,972.98) | |
30-Oct-20 | 419 | 56,260.00 | (848,232.98) |
Please solve for me.
Thanks in Advance.
Hello,
What about
dimension: date
measure: aggr(sum(balance),date)
Regards,
Not coming properly.
Is it the same or some other things is problem?
Still faced the same problem.
If more than one entry in the same date then system showing cumulative amount.
Hello, as far as i know if you dont have timestamp value with hh:mm:ss or sth to differentiate the date values, you will always see the sum of the balance for a single date.
Regards,