Re: % Complete or Visual Slider?

Tom_Cat · 05-12-2020 01:46 PM

Hi,
I have an app that tracks the status of orders, basically an order has certain steps:

Order Placed
In Queue
Assembling
QC-check
Packaging
Shipping
I currently have it set so that each time a new line is created the only available action is to “move it to the next step” and then it will log the date it was moved to the next step.
I was wondering if there is a more “visual” way to do this, (I was thinking of a slider with different positions) or maybe a table or chart where as the order progresses you can see a bar filling up or something thats not just a list of numbers.

There’s two things here that I want to elaborate on:

Is there a way to assign a value to each of the steps? I can imagine doing a chart but I want to make sure Order Placed has a value of 1, how can I set this?
When I display these as a list, how can I order them in the step without showing the number, how can I make the list put “Order Placed” at the top before “Assembling” (which would be the descending, alphabetical order)

Steve

If I recall correctly, you can use an Enum column, define these steps as values of the column, and assign an order to them. That ordering will be honored in views if you sort by the Enum column. I’m not sure what effect this would have on a chart, but it might be worth trying! Let us know!

Marc_Dillon

You could make a new table like this:

Where Number is the key, and Step is the label.

Then change your Enum column to a Ref column pointing at this new table. The Steps should be listed in the proper order by default this way, or you could make it explicit by setting Valid_if to something like:

ORDERBY( newtable[Number] , [Number] )

Now, since the Ref column actually holds the key value (Number), you can set your “Next Step” action to increment that column by 1.

As far as displaying a percentage completed, we can start by creating a new Percent-type column, with a formula like:

[Step] / MAX( newtable[Number] )

And here is a cool way to visually display percentage values:

Steve

@Marc_Dillon