As we can see, my Register in X Workflow state translates to a State Rank of -2015332743211050 in the data, which is arbitrary in the worst sense of its meaning…
Here are the current State Ranks in that database:
… before they were at least round positive numbers (i.e. 1 000 000, 2 000 000, etc.).
Until yesterday (or so), the formula to count all activated customers was what my first screenshot shows: COUNTIF([Id],[State Rank] > 3000000)
Today my colleague noticed that the number of activated customers was zero, and when I checked, I saw the the State Rank field suddenly has new values. So I had to change the formula to this: COUNTIF([Id],[State Rank] <= -1922380244664780.2)
Why is State Rank in a report an arbitrary number that can change? I understand that it is is needed to be a number for sorting, but it shouldn’t change. → I would suggest to split ID and sorting, so that the ID can be immutable and the sorting can be changed.
Why is the State Rank not something I can see when I alt+click the single select option, where I can give it extra properties? Listing it there would make it easier to use, tho Ideally I’d want:
Why is the State Name not be made available in reports?
Why does the State Rank get changed without me touching the options in the workflow properly?
Rank is a property that every entity in the workspace has. Its value is a relative number indicating a global ordering.
Here’s a superficial explanation of how it works:
Imagine I have two projects, four tasks, and a single select (workflow) field with three options.
They might have rank values as follows
In other words, if you were to show Tasks on a board, they would be sorted as Task 4, Task 1, Task 3, Task 2.
If you show Projects, they would be ordered Project A, Project B.
The options for the select field are Open, Done, In progress.
Imagine you add a new Task and drag it in between Task1 and Task 3. The new rank values will look like this:
that is to say, the new item is given a rank value halfway between the other two.
As you add new items (of any type) and as you drag items around, you will be assigning new rank values each time.
So imagine you now add a 6th task between Task 1 and Task 5 (it gets the number 425) and then you add one between Task 1 and Task 6, and so on.
Eventually as you add/change a lot of stuff, there would become no more space to fit new items in between existing ones.
Before this happens, Fibery does a ‘clean up’ in the background which involves updating all entities’ rank values, thereby creating extra space between them (without changing the overall order). This is how the rank value of an entity can change without you doing anything.
Rank is not an editable field, it can’t be used in formulas/automations, and most users don’t even know it exists, so there’s not much point in showing it on the GUI.
The absolute value of rank is not really meaningful/useful.
Rather, the relative value is what matters, and it is commonly used just as the sorting field in a report view.
It absolutely is. That was what my screen shot above was showing.
If you choose the data field called State you will get the state name.
If you do want to filter out specific states, you can filter on the State field, e.g. COUNTIF([Id],[State] == 'Activated')