Working with 2 Dimensions and 2 measures(Combo Chart)

[Ceb]

Hi,

I have the below dataset

Product	Group	Actual	Target
Apples	B	0.35	0.47
Apples	A	0.87	0.7
Apples	C	0.61	0.67
Onions	B	0.40	0.4
Onions	A	0.87	0.7
Onions	C	0.71	0.64
Bananas	B	0.30	0.44
Bananas	A	0.69	0.7
Bananas	C	0.62	0.65
Tomatoes	B	0.53	0.47
Tomatoes	A	0.94	0.7
Tomatoes	C	0.58	0.67

I am trying to compare the actual value of multiple groups of the product with the Target but I am not able to do it.

I can get this by using a bar chart but cannot add targets

If I want to add targets then I need to do something like this 3 times(for 3 different groups)

Is there a way where I can implement the target and the actual values with the group something like this

Thanks

[Arthur_Fong]

Try this:

This workaround is done by using Valuelist and inserting all dimension values into it:

Create the dimension using Valuelist:

=valuelist('Apple A','Apple C','Apple B','Bananas A','Bananas C','Bananas B','Onions A','Onions C','Onions B','Tomatoes A','Tomatoes C','Tomatoes B')

Then in expression, pick and match each value assigned using set analysis:

For Actual:

pick(match(valuelist('Apple A','Apple C','Apple B','Bananas A','Bananas C','Bananas B','Onions A','Onions C','Onions B','Tomatoes A','Tomatoes C','Tomatoes B')
,'Apple A','Apple C','Apple B','Bananas A','Bananas C','Bananas B','Onions A','Onions C','Onions B','Tomatoes A','Tomatoes C','Tomatoes B'),
avg({<Product={'Apples'},Group={'A'}>}Actual),
avg({<Product={'Apples'},Group={'C'}>}Actual),
avg({<Product={'Apples'},Group={'B'}>}Actual),
avg({<Product={'Bananas'},Group={'A'}>}Actual),
avg({<Product={'Bananas'},Group={'C'}>}Actual),
avg({<Product={'Bananas'},Group={'B'}>}Actual),
avg({<Product={'Onions'},Group={'A'}>}Actual),
avg({<Product={'Onions'},Group={'C'}>}Actual),
avg({<Product={'Onions'},Group={'B'}>}Actual),
avg({<Product={'Tomatoes'},Group={'A'}>}Actual),
avg({<Product={'Tomatoes'},Group={'C'}>}Actual),
avg({<Product={'Tomatoes'},Group={'B'}>}Actual)
)

For Target:

Change the measurement field to Target.

Refer qvf attached for reference.

Thanks and regards,

Arthur Fong

[Ceb · Accepted solution]

Thanks Jkfong93!!

That is one way to go about it. But the problem is if there are many products it could get complicated writing all of it.

I did it using tabs. Creating 3 tabs for the 3 Groups and plotted the target and actual values