This is a brute force way of accomplishing the goal but here goes
first I created a field that gave me a 1 on up days
if (MAX([Closing Price]) - [Previous Value])>0 then 1 end
if isnull(["UP Day Indicator"]) then 0
else ["UP Day Indicator"]+PREVIOUS_VALUE(["UP Day Indicator"])
when added to your viz they produce this
I am on a different version of tableau and you would not be able to open the workbook
Let me know if this helped
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks Jim, but not quite what I am going for. In your calc it looks like the count is restarting - the correct count is 5 days, your viz shows 3. I tried a similar construct, but instead of returning 1 / 0 , I tried returning the date value then I was going to just count the distinct dates, but that doesnt seem to work.
if MAX([Close]) - ([Previous ( CLOSE )]) > 0
THEN COUNTD([String (Date)])