topic Creating the number sequence in App Development

Creating the number sequence

glatocha — Mon, 02 Jun 2025 03:56:17 GMT

Hi,

I am plotting the products in production sequence in the order of production.
Unfortunatelly my data, does not have a filed "position in sequence" but the production sequence is sorted by
- order in sequence
- product in order

To have the bars sorted correctly I created a field Order*100+product.

Is there a way to create this as a normal numbers 1,2,3, ...

Here you can see:
order 1, products 1..3
order 2, products 1..3
...

Re: Creating the number sequence

Mark_Little — Mon, 02 Jun 2025 06:33:07 GMT

I would look to do this in script.

If you sort it in that order your could use PEEK or PREVIOUS function to create the numbering you like.

Mark

Re: Creating the number sequence

marcus_sommer — Mon, 02 Jun 2025 07:41:12 GMT

You may combine both information differently within a dual(), like:

dual(Order & ' - ' & product, Order*100+product) as orderProduct