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
daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
3 years ago

Are you talking about a measure or a calculated column? Also, what does it mean "only for dates within the past 1.5 months"? For a group that you'd use for the calc of average, there may be many different dates. Which dates are you then talking about for a group of rows? And what happens if at least one of the rows in the group that you'd like to calc the average for has a date that's not within 1.5 months from now?

  • 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.