Discussions
-
Case statement with multiple field conditions
Hello, I'm trying to write a beast mode fiter that looks for a condition in one field and also searches multiple fields to return a "yes" value. Seems simple enough, but... I want it to: Look in CPT code field and find all records with CPT code of 20610, then look in 5 diagnosis code fields to exclude the procedures that…
-
Stacked Group chart - sales by month by location by product category
I'm trying to build a chart that shows "sales totals" by Month by Location by Product Category... can't figure out how to structure it. Basically, I want facilities grouped by month and then sales by category in the stacked bar. I can't see how to control the groupings to get this to happen. (I'm new) Series (stacked bar):…
