The idea is to make a parallel coordinates chart. This is the background information. M2 represents the quantity we promised our customers. M5 represents the quantity te customer got. The parallel coordinates chart should have 2 Y axes, namely one for M2 and another for M5. The corresponding lines should be drawn from M2 to M5. (There should be also 2 slieders on both sides in order to allow the end-user to filter the specific range both from M2 and M5.)
For M2 there is a field in our data model: Field_M2 (it contains numerical values, such as: 8000, 12213, 14099...)
Fro M5 there is a field as well in the data model: Field_M5 (it contains numerical values, such as: 3232, 13433, 15455...)
Both fields are contained inside one table.
First question is - do I have everything (data) in order to make the described chart? And can anybody help me please with this chart? Thanks!
The challenge I see is with the dimension (X axis). How to display M2 and M5?
UPDATE_1: As mentioned before, both fields (Field_M2 and Field_M5) are contained insde on table. Sothe tables looks something like this:
Now I have no idea how to make a dimension (X axis) that contains only two values M2 and M5. Any suggestion?
UPDATE_2: So the first question to clear would be - what are the minumum necessary conditions in order to make a parallel coordinate chart? Does anybody have experience with parallel coordinates chart?
I am not sure that an extension is the solution to my problem, because end-users always ask additional functionalities. It would be more helpful, if you could help me understand the parallel coordinates chart, and to help me get the dimensions on the X axis. Here I am completely clueless.
In addition, I did not see an example in the links you sent me (only the description of the extension).
I'll look it up in detail later. Now I need confirmation in regard to this:
- it seems to me that the parallel coordinates chart HAS to have the following and ONLY the following building blocks:
and 1 expression.
The first of the two dimensions is for the values on th X axis. The second dimension is for the Y axis. AND it seems to me important to state that we will have so many Y axis (with values from second dimension) as there are different values on the x axis.
Calculation of the expression is made for the combination (Value on the X axis, value on the Y axis). Depending on that the it is positioned on the Y axis. This is done for every Y axis and the SAME Y values on every Y axes are connected.
Not sure i completely follow but it sounds roughly accurate.
For the slope graph extension here are the properties:
For the 'CustomerMix' example , its more complex and here is what the properties look like to adapt the line chart accordingly. For both of these i would suggest working with the samples directly. To be clear I am merely opening up the examples and exploring them myself in order to answer your questions.
The problem I am having with your chart is that it is always necessary to manually select the dimensions.
Would it be possible to make that ONLY two dimensions are always displayed on the X-axis? If yes, do you maybe know how?
UPDATE - OK - this is solved by deleting calculation condition in 'General' tab. My next question is - could you please explain the first expression in the 'Expression Tab'? (The name of the expression is 'Parallel coordinates chart (generic expressions)') What does it do, and why does it put '%' signs?
The thing is - what I want my chart to do is only to take the values contained in the first dimension (M2) and connect them with the corresponding values in the second dimension (M5)
UPDATE_1: So for example, if my table looks something like: