Help on chart report using multi groupings

[AWoody]

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

[Daniel_Clarke]

@AWoody 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.
Combination Chart

[AWoody]

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]

@AWoody - 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]

@AWoody 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!