Forum Discussion

KLibs's avatar
KLibs
New Member
2 years ago

Using a Measure Across Fields to Calculate a flag

Context:  I am calculating a survey average for the prior year across states, and I want to flag if a customer is in that state and gave a score lower than the state's annual average.    This is w...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago
but when I add the Customer ID to the table, it recalculates the measure to calculate the average for the customer,

 

That is not evident in your sample data. Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

  • KLibs's avatar
    KLibs
    New Member
    2 years ago

    I've edited the table - like I said in the post, it's just mock data so I'm trying to explain the issue I'm having, since I can't really show it. 

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.