Display Chart from Text Mode Grouping

Does anyone have any ideas on this one? I'm hoping there is something I'm missing. I have checked the documentation, but have not found anything that relates to charts generated from text mode groupings specifically.

Hi Michael,

Workfront report charts require that the data be "persisted" in the database, meaning that data calculated dynamically (via a valueexpression) cannot be charted.

That said, since both Program and Assigned To are persisted in the database, even though you're using textmode to get the Program (since it is "far away", hopping from Task > Project > Program), that might be too far for the chart engine to recognize. If so, you might need to "pull" the Program into (persisted) custom data at either the Project or (worst case) Task level, in order for it to be "close enough" to then chart.

For a bit more context (using a Portfolio example; similar but different), I invite you to read this How's My Portfolio? blog post.

Regards,

Doug

Hi @Doug Den Hoed‚ @Michael Keith - inactive‚ Looks like we are facing a similar issue,

when a reviewer rejects something on Workfront proof, we ask them to fill a custom form having fields like ""Reasons for Rejecting" having a dropdown with pre-defined categories.

Now, our users wants to see charts - displaying how many proofs got rejected for what reason.

We have been able to expose the field in basic reporting. But not able to use the text mode code to get grouping done.

Any leads will be highly appreciated.

FYI @Agnieszka Markuszewska-Shehata‚

Hi Juhi,

Since the Reason for Rejecting is already stored in a pre-defined (dropdown) of categories, you might not need textmode to chart it: you could simply add it to the report view, the report grouping, and set the chart (e.g. Column Chart) to show Record Count for the Y-Axis, Entry Date by Month (for example) as the X-Axis, and then Group the data by Reason for Rejecting (e.g. side-by-side).

Regards,

Doug

HP Inc, would need this urgently, thank you.