I have an Enum column with 3 choices
Accepted
Pending
Declined
I have slices based on those choices
(Iโve tried multiple ways to make this work again)
[Estimate Status]=Accepted - with and without quotes
CONTAINS([Estimate Status], โAcceptedโ) - with and without quotes
I get zero results now.
Ultimately the goal is to separate them and count.
Thanks!
Solved! Go to Solution.
Thanks Marc.
I disconnected and reconnected the tables and now they are working.
And yes I went back to my original expression which is =โacceptedโ
I think it may be a connection issue on my end. I work remotely, I mean Iโm actually in the desert camping while working on these apps. Iโve seen a performance difference between browserโs during this as well.
Anyway, most likely the problem is on my end.
Thanks for reaching out.
Please provide a screenshot of the slice configuration, being sure to include the row filter expression.
Hereโs a version with a CONTAINS
Hereโs another shot
Where are you seeing this unexpected result? Please post a screenshot of the emulator that demonstrates the problem, and includes the View and Table indicators.
Here you goโฆ
Tried this as well, still nothingโฆ
COUNT(SELECT(Estimates[Estimate Status], IN([Estimate Status], {โPendingโ})))
Not sure why you use contains or in expression with this.
just simply
[Estimate Status]=โAcceptedโ
for slice conditions
Iโve done that as well, both with and without quotes, still nothing in returnโฆ
Sanity check time. Make a temporary new VC in the base table with the expression:
[Estimate Status] = โAcceptedโ
Test this from the expression assistant, what does it show?
Are you using any Security Filters for this table?
Where did you get that last screenshot from, I donโt recognize it?
Thanks Marc.
I disconnected and reconnected the tables and now they are working.
And yes I went back to my original expression which is =โacceptedโ
I think it may be a connection issue on my end. I work remotely, I mean Iโm actually in the desert camping while working on these apps. Iโve seen a performance difference between browserโs during this as well.
Anyway, most likely the problem is on my end.
Thanks for reaching out.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |