Well, don't feel too bad about not passing the color tests at your initial medical!
It's worse when they fail you for it AFTER you spent all your money and effort in training!
My situation:
I failed the Ishihara test at my initial class 1 medical. I then was given the anomaloscope. The result was Deuteranomaly 5.25 and 2.15 for each eye. This was within limits at the time so I got the class 1.
Now I'm in Indonesia trying to get a medical validation for my first job. I fail the Ishihara test again. I've not been given any other specific colorvision test afterwards. They fail my medical. It turns out that they do not allow any form of color deficiency.
When I went for a 2nd opinion, the specialist tested me extensively including Ishihara and a lot of other tests, but no specific 2nd colorvision test. Because I did pass the medical in Europe, have a license and a rating, he tells me that I'm fit to fly.
Unfortunately, the DGCA of Indonesia did not concur and they still failed my medical.
Basically this means that I'm out of a job, on the other side of the globe, with a good amount of debt and no savings. (I've given all to get this job in the first place.)
Not getting the medical is bad, but maybe I would've been in a better position if I hadn't gotten it in the first place?