Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I don't know the difference between a measured and calculated column. I actually want the data to be averaged from the past year.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

calculated column:  is computed once during dataset refresh, and stored as part of the data model. Is not impacted by user choices.

measure: is computed on the fly whenever the user interacts with the report in a way that includes that measure. Is not stored in the data model. Is impacted by user choices/filters.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Actually, that would be great if I can have a measured column which uses the inputs on the page (which pick the years/year to include in the plots). How would I be able to get the column in the datatable to account for the filters on the page that is displaying? I didn't think those two things are connected.

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      You cannot calculate columns from filters. That's why you need measures.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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.