Hi All!
I am making a pretty simple application. I have different slices based on the month of a project.
My table is built as follows:
Project ID |. Project title | Month |
unique ID x January
unique ID y February
unique ID z March
The first slice which is โJanโ has a row filter condition of : ([Month]=โJanuaryโ)
It works perfectly, only selecting those projects where the month is January.
However, in my remaining slices the same formula of for example, ([Month]=โFebruaryโ) yields a list of unfiltered data. The expression assistant test shows the appropriate results i.e. Yes/No for the appropriate list of projects when inputting that expression. I have tried one of the solutions for slice woes in the community where the formula suggested is IN(โFebruaryโ, LIST([Month])) to no avail. Iโm pretty stumped on this one! Iโd appreciate any help
Other information that might be useful:
-My source has multiple tabs and has other tables where the column header โMonthโ is used
-The slice source table is set to the desired table
-The view in my application references the desired slices
Please post a screenshot showing the unfiltered data.
A bit late with the reply, but was able to solve the problem. If any one else happens to read this and wonder the same as I did:
Check your source Table. My app had two tables with the same name confusing it a fair bit. Simple fix but stumped me for a while!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |