How can I create a streak visualization?

[mrlanderson69]

To my table I am trying to add a column similar to the following:

It keeps track of the previous 10 days, and assigns a red dot to losing days (say when a certain number in my data is negative) and a green dot to winning days, otherwise white. How would I do something like this?

[yosiasz]

Could you please provide a sample data applicable to the image you postee. I am color blind with green red combo, so I cannot see the difference between 1 & 6

Here is an example using Dynamix Text visualization