ALL status transition dates (not just first and last)

Yes, you are correct. You can get the 2 transition dates per period correctly. However, you can switch to Day level and see activities per day. Unless you have 2 or fewer status changes to/from the same status you are good to go.

However, we would suggest using calculated JavaScript custom field for more complex scenarios with historical data entries.

We have some community posts on those topics. Here are some of those posts covering different scenarios:

Daina / support@eazybi.com