Help on chart report using multi groupings | Community
Skip to main content
W
WorkfrontWhiff
Level 3
June 5, 2025
Question

Help on chart report using multi groupings

  • June 5, 2025
  • 2 replies
  • 434 views

From a project report created, I am looking to create a line (or bar) chart with a second line graph report to illustrate the 2 groupings: a score from our creatives and a priority level score from the marketing team i.e. 1=urgent, 2=high, 3=medium and 4=low.

I have both calculated field successfully set up in Groupings and added the project name as a 3rd grouping.

 

This is what I want the chart to illustrate:

y axis = Score count (to measure creative score and also the number on the priority level  - 1,2,3,4) 

x axis = project name

Line/bar plotting 1 = marketing priority score

Line plotting 2 - creative score

 

Is this at all achievable? Can we do dual y axis? I think not, but it doesn't seem too unreasonable.

 

I have used Copilot to visualise it for me and attached

 

Thank you

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

2 replies

Daniel_Clarke
Community Advisor
Daniel_ClarkeCommunity Advisor
Community Advisor
June 5, 2025

@workfrontwhiff yes this is possible using the "combination chart" option after clicking on "column". Screenshot below for reference. Add your data points to both the grouping and columns to start and ensure it is all flowing in correctly.

    W
    WorkfrontWhiffAuthor
    Level 3
    July 16, 2025

    Thank you and apologies for the tardy reply.

     

    I have followed your instructions but I am stumbling since the creative score and the priority score are set up as a groupings and also in the columns, the option of selecting either of these in the combination column chart is not available:

     

    Daniel_Clarke
    Community Advisor
    Daniel_ClarkeCommunity Advisor
    Community Advisor
    July 16, 2025

    @workfrontwhiff - Can you confirm the format of your calculated field? I am guessing it is "text" which does not allow it to be charted. If so, you may need to deprecate that field and recreate selecting "Number" as the format. Unfortunately the system does not allow you to change that after the fact.

    If that field has already become well used as-is you can also create a new calculated field to support (ie, Priority Score - Number) that references the existing calc field with the adjusted format to test prior to doing a deprecation of the original. 

      kautuk_sahni
      Community Manager
      kautuk_sahniCommunity Manager
      Community Manager
      July 16, 2025

      @workfrontwhiff Just checking in — were you able to resolve your issue?
      We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!

      Kautuk Sahni
      Terms & ConditionsAccessibility statement

      Loading footer...