1 2 Previous Next 15 Replies Latest reply on Nov 16, 2017 2:31 AM by Zhouyi Zhang

Hello All,

I have a requirement where I would like to create 4 quadrant based on the actions and place the products accordingly.

something like below.

Appreciate any input.

• ###### 1. Re: Quadrant based on KPI

Hi, Vikas

You can create two groups based on action.

Workbook attached for your reference with 10.3

Hope this could help

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Quadrant based on KPI

Are you after something like this ?

Just 4 sheets with a filter on the Action and then place in the proper order on the dashboard.

I'm using 10.3 but I can make a 10.1 version if you need it.

1 of 1 people found this helpful
• ###### 3. Re: Quadrant based on KPI

Thanks ZZ & Chris,

This will help but I am looking for something like this.

1 of 1 people found this helpful
• ###### 4. Re: Quadrant based on KPI

I don't understand how you can do that with the data provided.  Where do you get the X and Y axis values from ?

1 of 2 people found this helpful
• ###### 5. Re: Quadrant based on KPI

Chris McClellan wrote:

I don't understand how you can do that with the data provided. Where do you get the X and Y axis values from ?

This is EXACTLY the question I want to ask too

Regards.
Lei

1 of 1 people found this helpful
• ###### 6. Re: Quadrant based on KPI

Hi Vikas,

There is a simple way out to do this is to create a calculated field and apply thresholding in colour section as below:

IF [Action] = 'Fulfilled by Order' THEN 1

ELSEIF [Action] = 'Place Order' THEN 2

ELSEIF [Action] = 'Cancel Order' THEN 3

ELSEIF [Action] = 'No Action' THEN 4

END

Make this field discrete and make it dimension and move this field to color mark card. Use the respective measures you need for the scattor plot and then play with the measure axis to get four quadrant as i did:

Please let me know if this trick helps you.

Thanks & Regards,

Jayshree Dawrewar

2 of 2 people found this helpful
• ###### 7. Re: Quadrant based on KPI

Hi, Vikas

Here is another solution according to your description.

Hope this could help

ZZ

1 of 1 people found this helpful
• ###### 8. Re: Quadrant based on KPI

Hi ZZ,

Thanks this is what I am looking for. the only catch here is that the quadrant are not symmetrical. depends on the average value.

Is there any easier way to achieve it?

Thanks

Vikas

1 of 1 people found this helpful
• ###### 9. Re: Quadrant based on KPI

Hi Chris,

Can you share the workbook? this would be interested way to put in the dashboard too? (along with the scatter plot)

thanks

1 of 1 people found this helpful
• ###### 10. Re: Quadrant based on KPI

Thanks Jayshree for the input.

1 of 1 people found this helpful
• ###### 11. Re: Quadrant based on KPI

Hi, Vikas

Yes, we can do that.

Please find below snapshot and attached workbook with version 10.3 as well.

ZZ

1 of 1 people found this helpful
• ###### 12. Re: Quadrant based on KPI

thanks ZZ & everyone.

Thanks

• ###### 13. Re: Quadrant based on KPI

ZZ

• ###### 14. Re: Quadrant based on KPI

I am trying to do something like this . Only thing is that It is coming in rows and not in quadrant . I did like this :

And I am trying to create something like this :

I want to keep the colors intact i.e Red , Green ,Yellow , Gray

1 2 Previous Next