How to reduce Workload units

[bri.bubble01]

I want to make the Sales table per day and per customer( below picture).

Now, set workflow like below.
①the create table button clicked, set sate 「customer_list：do a search for customer」「date：date timepicker’s value change date to 1 & time to 0」
②schedule API workflow
③create a new temporary type
D1 = do a serach for sales type filtered price sum (date=1, customer code= first items)
D2 = do a serach for sales type filtered price sum (date=2, customer code= first items)
D3 =do a serach for sales type filtered price sum (date=3 customer code= first items)
④Schedule API
customer_list muinus items first item
only when customer_List_count > 1

This process works without any problems.
However, just one operation consumes 1000 workload units.

Please let me know how to reduce workload units consumption.

[Jici]

First step is to lookmif you can change for a achedule workflow on a list (sawol). The other option could be to use trigger event instead of schedule workflow

[bri.bubble01]

Thanks your reply.
you mean that don’t use backend workflow?
How can I set the workflow without backend workflow.

Please show me the detail method?

[Jici]

No . You continue to use backend wf. But instead of doing a recuring wf, schedule wf on a list instead. Or use DB trigger to create your daily thing. I’m on mobile, so it’s hard to detail, but there’s a lot of example on the forum. Also, using a DB type:minus item is a bad practice actually. Better to use a list of text and store the unique_id. Look for recent topics from @boston85719 or @georgecollier and me about using sawol.

[bri.bubble01]

I understood using backend wf.
but I don’t know how to set “schedule wf on a list instead. Or use DB trigger”.
I’ll take a look at the topics you introduced.

If you have a time after, please show me how to set method.
Thank you very much.