Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a line chart with two dimensions, let's say Year and Continents (EUR, ASIA, AUS).
I use various conditional expressions. In the simplest form, I have two expressions. A sum of Values1 and a sum of Values2. Normally, for 1 expression I get 3 graphs (one for EUR, one for ASIA and one for AUS) with Year on x axis. But if I put a second expression I don't get 3 more graphs as I would expect, but 1 for Values1 (total for all continents) and 1 for Values2.
I want to have a number of graphs that is multiples of 3. 3 for one expression, 6 for two etc. That should be possible, right?
Hi.
It's chart limitations.
More than one expression go to legend, and some dimensions are ignored.
You have to create separate expressions for EUR, ASIA, AUS.
Or you can create one complex expression with one common dimension.
Also you can try to use overplayed transparent objects depending on your requirements.
Hi,
can you please post an example so it can be clearer?
regards
Thanks for the answer. I think option 1 and 3 might work. But generally I don't like customized solutions but general, so as not to update the document when new data is added.
The transparent object might work, I have never thought of that! Also I can try the separate expressions but as I said they have to be updated if something is added. A complex expression with one dimension will not produce the 6 graphs though.
Hi.
You don't have to update it.
Create secondary dimension =ValueList('Sum1', 'Sum2')
And try expression =if(ValueList('Sum1', 'Sum2')='Sum1', Sum(Value1), Sum(Value2))