Hi,
This app is for scan barcodes and updates data for gas reading.
I have a “database” table that includes all the names referenced to the barcodes.
the other table is “Reading”, which records all the gas reading
I’m trying to create a slice that includes all the barcode that left to do (from the database table)
let say I got 50 readings from 55 (55 are the total), that means I got 5 barcodes left, now I want a slice
of it.
I had tried:
in([barcode],db[Barcode]-select(reading[barcode],[_THISROW].[ID1]=[ID1]))
I hope I have made myself clear…
thanks in advance
This?
NOT(IN([barcode], SELECT(reading[barcode], ([_THISROW].[ID1] = [ID1]))))
It seems right. but it shows me all the barcodes.
in addition, the slice should be a tab on a dashboard…
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |