Combining Multiple Calculated Fields into One Chart | Community
Skip to main content
Laramie_Newborn
Laramie_Newborn
Level 2
January 21, 2026
Solved

Combining Multiple Calculated Fields into One Chart

  • January 21, 2026
  • 2 replies
  • 60 views

I’m pretty sure this isn’t possible but, I am trying to combine 3 different calculated fields on the same custom form into one chart. 

The fields are Metric 1 On-Time, Metric 2 On-Time, Metric 3 On-Time and the calculation spits out either Yes or No once dates from the source fields have been filled out (not all 3 metrics will apply to every project).

The goal is to determine the overall percentage of “Yes” vs “No” across the entire portfolio of projects, inclusive of all 3 metrics.

    Best answer by skyehansen

    Yes, you’re right, it might not be possible. Essentially what a report does is list out each item ONCE FOR THE COUNT.  What your question is asking is “hey can I count this item once for each metric -- so, a total of 3 times. Once for the yes, twice for the two no’s, for example.”

    The way workfront reporting happens to work, you need to find an object that represents what you are trying to count, only one time. It’s a pity that each metric isn’t being presented by a task for example, because then each task = one metric only, and you could make a count per portfolio of all the metric 1, 2 and 3 tasks instead.

    As it is, I don’t see any potential in any of the workfront charting functionality (you could maybe set up some total count calculated fields -- i.e. count all the yes’s, count all the no’s -- and add them up across projects, but don’t think you could chart both on the same chart. You could put a no chart and a yes chart side by side. You could take it into canvas dashboards and do KPI charts). Other than workarounds, you’d be better off taking this offline into excel or powerBI instead, in my opinion.

    2 replies

    KellieGardner
    Community Advisor
    KellieGardnerCommunity Advisor
    Community Advisor
    January 22, 2026

    If you are trying to do this at the report level, just know you can’t use text mode columns in charts, so it’ll have to be done at the object level somehow. 

    I would suggest an additional calculated field that aggregates the data from the 3 other fields into a single field and then report on that. 

      Laramie_Newborn
      Laramie_NewbornAuthor
      Level 2
      January 22, 2026

      If there is a way to do this, my thought was also an additional calculated field. I’m unsure on how to achieve this calculation though considering that the values are text instead of numerical and not all 3 metric fields will have a value in them. 

      Any thoughts on the syntax for the aggregation calculation? 

      KellieGardner
      Community Advisor
      KellieGardnerCommunity Advisor
      Community Advisor
      January 22, 2026

      You could do a series of IFs combined with OR statements.

       

      example:

      IF({DE:On Time 1}="Yes"||{DE:On Time 2}="Yes"||{DE:On Time 3}="Yes","On Time")

        skyehansen
        Community Advisor and Adobe Champion
        skyehansenCommunity Advisor and Adobe Champion
        January 22, 2026

        I’d love some clarification on “not all 3 metrics will apply” and “percentage of “Yes” vs “No””.

         

        For example, clarification on “not all 3 metrics” -- this would be clearer if you confirm “only one metric at a time”, or “sometimes 1, sometimes 2, sometimes all 3”

         

        Then, in terms of percentage of Yes vs No -- if there are times where 2 or 3 metrics fields might be filled in, do you could each Yes separately? So is that Metric 1 on time but Metrics 2 and 3 were late? So do I count 1 yes and 2 no’s? Or does ANY “no” mean the whole project counts as one “no”?

          Laramie_Newborn
          Laramie_NewbornAuthor
          Level 2
          January 23, 2026

          All projects will at least have Metric 1, only some will have 1 & 2, and only some will have 1 & 2 & 3. 

          Each metric has it’s own date entry fields so, Metric 1 may be “Yes” but Metric 2 may be “No” on the same project. 

          Ultimately, across all 3 Metrics on all projects in the portfolio, I would like a combined bucket of “Yes” calculations and a combined bucket of “No” calculations that I can put into a pie chart format in the report. So, each entry is a count towards the respective bucket.

          skyehansen
          Community Advisor and Adobe Champion
          skyehansenCommunity Advisor and Adobe ChampionAccepted solution
          January 23, 2026

          Yes, you’re right, it might not be possible. Essentially what a report does is list out each item ONCE FOR THE COUNT.  What your question is asking is “hey can I count this item once for each metric -- so, a total of 3 times. Once for the yes, twice for the two no’s, for example.”

          The way workfront reporting happens to work, you need to find an object that represents what you are trying to count, only one time. It’s a pity that each metric isn’t being presented by a task for example, because then each task = one metric only, and you could make a count per portfolio of all the metric 1, 2 and 3 tasks instead.

          As it is, I don’t see any potential in any of the workfront charting functionality (you could maybe set up some total count calculated fields -- i.e. count all the yes’s, count all the no’s -- and add them up across projects, but don’t think you could chart both on the same chart. You could put a no chart and a yes chart side by side. You could take it into canvas dashboards and do KPI charts). Other than workarounds, you’d be better off taking this offline into excel or powerBI instead, in my opinion.

            Terms & ConditionsAccessibility statement

            Loading footer...