Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have been successful in creating individual tables with the below criteria, but It has been requested by my boss to combine and only show the results when the criteria have been met. Any suggestions?
Any Time | |||||
Show Unit ID, MAT, and status when MAT below 48F | |||||
When OA is 83 and above | |||||
Show Unit ID, MAT, and status when MAT above 78F | |||||
When OA is above 70F and below 83 | |||||
Show Unit ID, MAT, and status when MAT above 75F | |||||
When OA 50F or below | |||||
Show Unit ID, MAT, and status when MAT above 70F | |||||
When OA above 50F and below 70F | |||||
Show Unit ID, MAT, and status when MAT above 72F |
Solved! Go to Solution.
@Anonymous i am guessing OA, Unit ID, MAT & Status are all columns in 1 table.
you can write a swithc with following criteria
SWITCH(TRUE().
OA >= 83 && MAT < 48,"Y",
OA >= 70 && OA < 83 && MAT > 78,"Y",
"N")
Feel free to add the required conditions to create the filter and then filter results based on it.
Hi @Anonymous,
Could you please share you sample data here so that I can help with it?
Regards,
Frank
Ideally, I don't want to use bookmarks.
@Anonymous i am guessing OA, Unit ID, MAT & Status are all columns in 1 table.
you can write a swithc with following criteria
SWITCH(TRUE().
OA >= 83 && MAT < 48,"Y",
OA >= 70 && OA < 83 && MAT > 78,"Y",
"N")
Feel free to add the required conditions to create the filter and then filter results based on it.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |