Which chart suits best?

[#1]

Hi,

Can anyone suggest me please which chart will suit if there is two dimensions and three expressions to show as a graphical representation.

Thanks.

[alexandros17]

Scatter Chart or Grid Chart

[#3]

Thanks. Is there any other chart would suit? because these two not looking god with data. Please suggest

[#4]

What are you triying to measure ?

Could you provide an example ?

[#5]

Thanks. please see below

Dim 1 = Week

Dim 2=  Customer

Exp 1 =Count(If(MixMatch(Details,'outcome','outcome to','Exclude','outcome Reduce'),ID))

Exp 2 =Count(If(MixMatch(Details,'Proper','Proper to','Poland','Proper Into'),ID))

Exp 3 = Exp 1+Exp 2

[#6]

If it can´t be a pivot table I would go for the trellis option in the dimensions tab so you can have a different chart (bar chart) for every week.

[Colin-Albert]

Another other option could be to have the 3 expressions as a cyclic group, so your chart would have 2 dimensions and one cyclic expression. Just use the Group option on the expression tab.

[#8]

Thanks. when I am using Trellis it is showing too few dimensions. how can I set this?

[#9]

Thanks. how to make the expressions as Cyclic. Please suggest me.

[#10]

U can use Grid chard, but it required 3 dim and 1 expr, in case u can create 3rd dim with expression list and one expr. image and sample included.

isnt best solution, but original 😃