Is there any way to minimize slices? / (Simplize data sheets)

[sunnysideupair]

Hi, I'm making an app that reports some issues in the factory.

Here's my screenshots.

It works well, but I made 20 slices and 20 views to make this app work well.

Like THIS)

20 Slices)

All Factory)
Not Started, Row filter condition : [Status]="Not Started"
In Progress, Row filter condition : [Status]="In Progress"
Complete, Row filter condition : [Status]="Complete"
Denied, Row filter condition : [Status]="Denied"

Factory 1)
Not Started, Row filter condition : AND([Factory]="Factory 1", [Status]="Not Started")
In Progress, Row filter condition : AND([Factory]="Factory 1", [Status]="In Progress")
Complete, Row filter condition : AND([Factory]="Factory 1", [Status]="Complete")
Denied, Row filter condition : AND([Factory]="Factory 1", [Status]="Denied")

Factory 2)
Not Started, Row filter condition : AND([Factory]="Factory 2", [Status]="Not Started")
......

And 20 Reference Views)
>> For this data : (All Factory, not started), ... , (Factory 1, not started), ..... total 20 referance views

And 5 Menu navigation)
All factory, View entries : Not Started, In Progress, Complete, Denied
Factory 1, View entries : Not Started/Factory1, In Progress/Factory1, Complete/Factory1, Denied/Factory1
Factory 2, View entries : Not Started/Factory2, In Progress/Factory2, Complete/Factory2, Denied/Factory2
...Like this for factory 3, 4

But this is little bit annoying because if I have to change one's view then I have to change other view same, in 20 times.

Is there simpler way to work like this? (If I change one, I want the rest to be applied at once.)

[Suvrutt_Gurjar]

In general, if you do not wish to see all the 20 factories simultaneously , you could use user based slicing.

Please take a look at the following sample app. 

Slice based on user input - AppSheet

Basically , in the sample app, the slice expression is made dynamic. wherein user selects the color and the chart changes to represnt values for that color. In your case you could have filter for the factories such as "Factory 1", "Factory 2" ........., "Factory 20"

The sample app is single user based. You will need to have a USER table with one row per user to store the selections of each user. This will enable multiple users to see different factories data as per their selections.