Ignore dimension for an expression in a Chart

[rajeshvaswani77]

Hi Community,

I have a Line chart, Two Dimensions and two Expressions.

I want expression1 to consider only dimension1 and ignore dimension2, however expression2 must consider both of them.

Is there a way to achieve this, right now since  expression1 is considering both the dimensions the chart is getting distorted.

I have linked table and two facts on either side. The dimensions and expressions belong to both the facts.

I have a solution where I can superimpose two charts and have transparency, however during export this will be an issue.

Have tried the dimensionality, but not able to make it work.

Any suggestions, please post.

thanks,

Rajesh Vaswani

[sunny_talwar]

‌Have you tried it with the Total qualifier? Try: Sum(TOTAL <Dimension1> Value) (you may need to replace Sum with what ever type of aggregation you are trying to do) This is for the expression 1 which only needs to consider Dimension1.

See if that works, if it doesn't would you be able to share a sample?

HTH

Best,

Sunny

[sunny_talwar]

Just to add, there is also a possibility to use an aggregate function, but will need to know what is your data looks like and what is the expected output. Aggregate might look like this:

Sum(Aggr(Sum(Value1), Dimension1))

Attaching a dummy application for you to see.

Best,

Sunny

[svenkita]

Sample screen shot

2 dimensions : year and month

Expression 1 is sum(sales) based on year and month

Expression 2 & 3 are based on the Year dimension only.

Sample file attached

hope this helps