Apply groupings to UI only field in an aggregate chart

  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have an aggregate model showing time taken per step (i.e. grouped by name of step).

There are different targets per step. Is it possible to create a UI only field to be a target per step (where each step has a different time target)?
Photo of Dave

Dave

  • 126 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Dave,

I think I see what you are trying to do.  You have a model that groups by step with a sum of time per step.  You want 2 fields one where the time per step (for example) is >0 and <10 and the second is >=10 and <=100.  What I would do is create 2 models: one to aggregate steps for the first condition (>0 and <10) and one to aggregate steps for the second condition (>=10 and <=100).  In the second model add a Model UI Formula field with a Model Lookup function to pull in the other value.

Thanks,

Bill