2 Line Chart, repeating date issue?
I'm attempting to make a 2-Line Chart that tracks the following data (simplified for troubleshooting)
The DATE and AMOUNT that two Entities have been paid.
Here is my current table --
As you can see, both entities get paid on the same day. But when trying to create a 2-line chart, I get this:
As you can see, the dates are doubled, and I would like them to be on the same line. I also included the calculation that i used for each Y-Series.
What should I do? Thank you!!!