Hi, Jim. Thanks, but that didn't work for me. Though my table has 1s and 0s, I edited the thread to indicate my status values are text values, like "active," "inactive" etc. And I am trying to make a bar chart showing the count of status changes over time. Hopefully your calc just needs a tweak.
sew the attached -
all I added was a running sum of the change indicator
this will find the changes - makes no difference if you use 1 and 0 active inactive - the expression in words says if the status value of this record is not the same as the preceding record then 1 else 0
it is calculated as
this will sum the indicators
it is set up the same way
and it will return this with your initial data
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.
change customer_v10.2.twbx 2.4 MB