Grouping by a calculated column

[philipr52065527]

Title says it all, can it be done? P. Phillip Rinehart New York University

[NRYNR]

Hi Phillip, I don't think you can group by a calculated column but I'm optimistic this might work. If not, you'll probably need that calculation on the column to live in a calculated field on a custom form and then group by the value, which also gives you charting if you need it. I'd try putting your column's valueexpression into this format: group.0.displayname=Group Name group.0.valueexpression=CALCULATION_HERE group.0.valueformat=HTML textmode=true Let us know how it goes! Narayan Raum "https://suntrustedo.my.workfront.com/dashboard/view?ID=5c1bf1f90046e70adeecf882731a47b9"> Workfront Center of Excellence Delivery Lead Enterprise Data & Governance Execution (EDGE) SunTrust Bank

[philipr52065527]

Hmmm, o.k. I'm not sure how this would work in practice, as I'm using the case statement, like this: case.0.comparison.icon=false case.0.comparison.leftmethod=project:name case.0.comparison.lefttext=project:name case.0.comparison.operator=cicontains case.0.comparison.operatortype=string case.0.comparison.righttext=Ongoing case.0.comparison.truetext=LLLLL and so forth. There is no value expression to subsitute. P. Phillip Rinehart New York University

[NRYNR]

Your valueexpression might be: IF(CONTAINS("Ongoing",{project}.{name}),"LLLLLL","Other text") I was able to use this valueexpression in a report: And it worked: Narayan Raum "https://suntrustedo.my.workfront.com/dashboard/view?ID=5c1bf1f90046e70adeecf882731a47b9"> Workfront Center of Excellence Delivery Lead Enterprise Data & Governance Execution (EDGE) SunTrust Bank

[philipr52065527]

Perfect, worked like a charm. Is there a way to expose this so the chart can use the grouping? Right now it isn't available, or rather if I use it, an error is thrown. Phillip Rinehart New York University

[NRYNR]

For this to be a chart, you would have to perform the calculation on the object's custom form in a calculated field. Narayan Raum "https://suntrustedo.my.workfront.com/dashboard/view?ID=5c1bf1f90046e70adeecf882731a47b9"> Workfront Center of Excellence Delivery Lead Enterprise Data & Governance Execution (EDGE) SunTrust Bank