PA - How to compare two indicators on a column visualization widget for a common breakdown

JonWest1021
Kilo Contributor

Hi Team,

I'm stuck on something that feels like there's an easy solution I can't quite find. I have two PA indicators, something along the lines of planned vs actual. I want to visualize them on the same widget like pictured below. Horizontal access is a breakdown (specifically in my case its in the form of bucket groups). Using a list widget or a breakdown pivot scorecard I can compare any two indicators across a common breakdown. But I can't find an option to graph them in any way that compares them. Am I just missing it? It's been known to happen. Thanks for your help!

find_real_file.png

5 REPLIES 5

Tracy Davis
Giga Guru

You can add a second indicator to the widget to get something to look like that.

On the lower section of the widget, there's a tab that says 'Widget Indicators' - you can add the second one here. Just make sure the breakdown is on both indicators and make sure both have the same type, visualization, and time series selected

 

Thanks Tracy! I see this option for a time series column widget. However I don't see the widget indicator button available for breakdown type widgets. I wouldn't be able to plot this chart along a time series. What widget 'type' do you suggest? If I can do this it will be awesome. Thanks for your support!

Hm, I missed that part. You're right, looks like they don't allow that option for a breakdown view. The option does pop up for a breakdown with the Pivot Scorecard visualization, but that certainly doesn't give you this nice column view though.

I ended up plotting them side by side. Users can make the comparison but its not ideal. And the y-axis is slightly different since they have different min and max values. I appreciate you taking another look. It kind of confirms for me that I'm not losing it. I'll stay tuned if anyone else has an idea but it looks like I'm a little stuck if I want to see it visually. You're right about the pivot scorecard, I maybe could augment this view with that additional dimension. Thanks!

 

find_real_file.png