I have a table that I am making a slice and every time I enter my โRow filter conditionโ - it disappears. Is this a bug?
Saved expression:
Solved! Go to Solution.
Try this as the slice row filter expression
([_THISROW] = MAXROW("DSO for all divisions", "Date"))
Did Expression Assistant open? Did you save your expression from within Expression Assistant?
Weird -you asked that. No the expression asst did not open. I did save it,
I suspect the behavior youโre getting is due to a recent enhancement to slice row filters. Did you get a dropdown that offered suggestions?
No. I had to type the expression in the area/field, then click enter. Then the suggestions popped up. However, once I clicked โCustomโ - while inside the expression builder - it never showed the data (Column names etcโฆ) It was weird.
@natalie, can you help here?
@Tiger , sorry youโre getting some confusing behavior here. Yes, writing slice row filters was broken by an unrelated change. Please stay tuned for a fix. Thanks!
@Tiger As a workaround, please type into the box first, then click โCreate a custom expression,โ then that should open Expression Assistant.
It does. But after I save- it doesnโt show the expression in there anymore?
Oh my apologies, I misread the original problem. When youโre in the Expression Assistant, can you make sure youโre using the formula field, not the description field?
Now it is giving me an error?
Ok good, we resolved the first issue. That error is expected. Let us know if following โMore infoโ and reading the linked docs does not give you the info you need to resolve the error
How does mine differ from the one I find in appsheet help?
Mine:
Appsheet help:
MAXROW() returns a row reference, not a Yes/No value expected from a slice row filter expression.
Oh. Ok. Thanks
Steve - I must be using the wrong expression then. I am trying to email (auto) the latest rows depending on [Date]. In other words, I want the latest rows of data emailed based on [Date] columnโฆ
How do I do this?
Try this as the slice row filter expression
([_THISROW] = MAXROW("DSO for all divisions", "Date"))
That worked. Thanks as always Steveโฆ
Steve,
When the email ran this morning - no data was there? Meaning it did not show the latest rows of data:
This data should have been there, right?
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |