Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a pivot table with "Transaction Date" Row Field and a measure "Total Payments Posted"
The expression for "Total Payments Posted" is (Sum({<ITEMTYPE={'I-P','P-P','P'}>}Trans))*-1
Where item type is another field that represents payment type, and trans represents the amount. Payments are negative in the database so I Multiply by -1 so the total will appear as a positive in the visualization.
However, I cant figure out why the dates are repeating in my visualization?
I am connected to 4 database tables all having the same field names and concatenated in my data load script.
Thanks in Advance.
Your date might be a timestamp... convert it into a date field like this
Date(Floor("Transaction Date")) as "Transaction Date"
Your date might be a timestamp... convert it into a date field like this
Date(Floor("Transaction Date")) as "Transaction Date"
Yes! Thank you that solved the problem.