How do i count in a refrence table in a dash view?
My senario is like this:
I have a Table of my assignemnts, they have a weeknumber where they are to be done and they have a column with the cabinet i am to installโฆ
I have a Table of only weeknumbersโฆ
I have a table of cabinet typesโฆ
In my Deskview i have a choice of wook number that makes my assignments for that week show and a map that shows where the assignment is located.
now i tried to add the table of cabinet types to the deskview to be able to see witch cabinets that i need to pack for that week but it is just showing the total numbet of cabinets and not only the once i need for the selected week.
Welcome to AppSheet!!!
The Header doesnโt seem to match the description and I think its creating confusion on what you are asking. that is probably why you havenโt had a response yet.
To make things more clear, could you provide a screen shot of where you are seeing an issue? It may help us to understand what you need.
Create a slice for Jobs that are due this week with a formula- something like
[Weekdue]= WEEKNUM(TODAY())
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |