How to create a report with different datasets?

[Robert Campbell]

I'm creating a chart for a dashboard within Platform Analytics

The problem is that the slopes don't look right because there are different scales on this one chart. One on the left and two on the right. I need them all to be using the same scale and here's what I'm trying to do.

I am trying to show a graph of 

1. All release tasks that are assigned to one group and created last year.
2. Out of all the above releases, how many of them has "PRE" in the short description (I know there will be false positives but that's the best we can do)
3. Out of all the above releases, how many of them has "POST" in the short description.

I would like to see 3 lines on the same chart and scale reflecting the different data. However, because 2 and 3 are technically different datasets, there aren't as many results.

[Matthew_13]

Hi Buddy,

Platform Analytics is auto-scaling your lines because you’re using three separate metrics. Since PRE and POST have much smaller counts, PA puts them on different Y-axes, which makes the slopes look wrong. There’s no setting to force multiple metrics onto the same scale.

The fix is to use one metric with breakdowns instead of three metrics.

Create one indicator for “All release tasks” (filtered by group and last year), then use a breakdown on the short description to split the data into PRE, POST, and everything else. Build the chart with that single indicator and the breakdown.

That gives you three lines, one Y-axis, and accurate slopes. 🙂

@Robert Campbell - Please mark Accepted Solution and Thumbs Up if you found Helpful

[Robert Campbell · Accepted solution]

I don't see how to add a breakdown to this. However it gave me something to consider and focus on which brought me to my first thought, group by.

Group by doesn't work in this case because you can only select one field to group by. I can add more but it will only show that one at a time.

What I ended up doing is setting the Y axis range and setting each one to the same. Now it looks right.

[Matthew_13]

@Robert Campbell - I think you accidentally ACCEPTED your OWN post. 🙂

You can update by just accepting button on any other post.

[Robert Campbell]

That's odd because I didn't accept anything as the solution although what I did worked. You comment about there not being a way to put them on the same scale made me look harder which is how I found out you can set the scale for each. I marked yours as helpful and left it at that. Is it possible an admin set it or maybe some A.I. did it?