Forum Discussion
Average By Columns with Filter and Dates
Hello, I have many columns and I would like to average using a filter and certain columns. So I want the "Value" field to be the average by Analyte, but only when AnalyteType = "Lab", and also only f...
lbendlin
Super User
Super UserYou cannot calculate columns from filters. That's why you need measures.
Yes, that's why I think a measure might be great. Can you show how I would do it? I looked up and saw that you put measures in the reporting/display area. What would the measure equation look like to account for all the columns I showed above? If it is on the page, then I wouldn't need the date filter because the page is already taking care of that. Thanks.