It would be helpful to know exactly what numbers you are expecting for your example data. Right now it shows:
Days in Interval CNTD(account_href) 1 2787 -1
What should the numbers be?
I am not exactly sure what you're use case is, but Displaying Active Records Over Time | Tableau Software may be helpful.
Generally speaking any one calculation can only have on result per record in the underlying database. So if a single [account_href] needs to be categorized in one than one category you can either make multiple calculations, or create a join that duplicates the rows in the underlying database. If I knew exactly what your end goal is, I could be more specific.