How to create a report with different datasets?

Robert Campbell
Tera Guru

2 hours ago

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

 

RobertCampbell_0-1769115287630.png

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.

 

0 Helpfuls
  • 56 Views
1 REPLY 1

Matthew_13
Mega Sage

an hour ago

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

0 Helpfuls