Can a report have two different Y axis labels?

[Travis Michigan]

Is it possible to create a report that has two different Y axis labels?  Perhaps one displaying its label for the Y axis on the left and the other on the right?

I'm trying to combine a couple reports about the same tickets, over the same period of time, one one of them displays the number of tickets in a stacked column per assignment group, and the other shows the amount of time worked per assignment group.  Currently we have a dashboard with the two reports next to each other, but would like to create a report so that it shows both sets of data on one report to easily view all the data in the necessary timeline.

When I have been trying to combine the reports using multiple data sets, if one is count and the other is Sum of Time it only displays one of them on the report.   As soon as I change it so they are the same metric (time or count) they display both data sets.  So I'm not certain if I am just missing a necessary step to make this work, or perhaps not noticing an option I need to use, or if perhaps it isn't possible?  

Any pointers/assistance is much appreciated!  

[Dr Atul G- LNG]

Hi @Travis Michigan 

I think not but I would like to hear from experts.

[AndersBGS]

Hi @Travis Michigan ,

As far as I recall, you can enable a second scale (Y axis) by opening your second dataset and goind to Style -> Axis and check "Show as a right Y axis". This would display the two series of data at the scale of each Y axis.

if you instead utilize performance analytics, then you can also have two y-axis whiteout issues.

if  my answer as helped with your question, please mark my answer as accepted solution and give a thumb up

Best regards

Anders

[Tai Vu · Accepted solution]

Hi @Travis Michigan 

Let's attempt the following approach to enable the two sides of the Y Axis.

In your Dataset report, go to the Style tab. Then, check the "Show as a right Y axis" checkbox.

Save and enjoy your result.

Cheers,

Tai Vu