Can you group by a Text Mode Column in a report? | Community
Skip to main content
K
KristinaWa1
Level 3
July 14, 2020
Solved

Can you group by a Text Mode Column in a report?

  • July 14, 2020
  • 1 reply
  • 1019 views

Good afternoon,

I was wondering if there was a way to group a report by a Text Mode Column.

I have a report that Text Mode to display if a task is On Time or Late based on the completion date:

displayname=On Time

textmode=true

valueexpression=IF({actualCompletionDate}<={plannedCompletionDate},"On Time",IF({actualCompletionDate}<={handoffDate},"On Time","Late"))

valueformat=

I would love to get this into a graph that would show the completion date and then split ones that were completed on that day based on if they were on time or late. But I am not able to select that custom column as a grouping. Just trying to avoid having to export into excel to sort them all the time.

Thank you,

Kristina

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by AngeloCo

    Yes, you would just rewrite your expression as a formula when building a calculated field, like so:

    IF(Actual Completion Date<=Planned Completion Date, "On Time", IF(Actual Completion Date<=Handoff Date, "On Time", "Late"))

    1 reply

    A
    AdinaPi1
    Level 9
    July 14, 2020

    Unfortunately grouping and charts can only be done if you create a calculated field on that object.

      K
      KristinaWa1Author
      Level 3
      July 23, 2020

      Is there a way to get the same result as I have above where it says if it is On Time or Late through a calculated field?

        K
        KristinaWa1Author
        Level 3
        August 19, 2020

        Angelo, thank you so much! That worked perfectly. I will be glad to not have to do any manual data manipulation to get the results we want! - Kristina

        Terms & ConditionsAccessibility statement

        Loading footer...