I looked at your doc, but didn’t copy it; instead reconstructed your pipeline within my doc, so that I could learn a bit more about how it all works. Super straightforward, and I should be able to use that skill from now on - so thanks again!
Onnnnly thing: This works for every Category except for “All projects”. For that one, of course, I don’t want a filter at all. I tried changing the button formula for that row - but it seemed to change all rows together. Is there a way to make the “All Project” button an unfiltered view?
Hi @Matthew_Shane ! This is a very good reflex. When I (often) post an embed, this is not to give you the finished document (otherwise I wouldnt explain at all ) but this is just to help if you’re stuck within the process.
You may have seen that I considered the “all project” case with two configurations :
the button “reset control value” that put the select 1 control to “blank”
the formula in the project table, I use If function, only if the control wasnt blank, otherwise I just set a dummy “1=1” thats always true, and then there is not filter at all.
Well, if you really don’t mind the queries: I don’t actually understand how changing from !=" " to !=All Projects led to this fix. How are the other columns still filtering by their respective row if the filter is set to All Projects?
the select 1 control dont mind, it takes “Finance”, “Manufacturing” or “All Project” as category.
So, if we go step by step for the filter of your project database
With the if function, we just want to deal with actual categories, that are NOT “All Project”. If they are different, we ask the project to be filtered with category that match the select control. If the selec control = ‘All project’, then we say a dummy equality so that the project table wont filter anything
Just create a column in your category table to make the reverse lookup link with the project database.
And then you’ve got access to full information from project database, for example the count of “project Name”, which is the count of project per category that you wish
Hey hey… I already know that you will think “that works for everything except for the row “All Project””. Yes ! because none of your project have the “All Project” Category
Then you can just create a new column with this formula to handle this , like we did before, and then show for each category the good count, and for “All project” the total count