Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two dimensions
1) Names
2) Dates
And two Expressions
1) Leftover
2) Done
TableFact:
LOAD * INLINE [
Name, Date, Leftover, Done
Name1, 01/01/2017, 100, 100
Name1, 01/03/2017, 80, 80
Name1, 01/10/2017, 50, 30
Name1, 01/12/2017, 30, 50
Name2, 01/18/2017, 150, 30
Name2, 01/20/2017, 120, 40,
Name2, 01/25/2017, 80, 0
Name3, 01/25/2017, 200, 20
Name3, 01/26/2017, 180, 30
Name3, 02/03/2017, 150, 100
Name3, 02/10/2017, 50, 20
Name3, 02/14/2017, 30, 0
];
I need two separate Areas with two expressions divided by two dimensions.
The visualization is like in the attached qvw file (it shows how should looks each Name).
- Each expression has to show separate area.
For 'Leftover' first Area and second Area is for 'Done' expression(Is it possible to create in one layer?)
- Each Name has to be in the period by dates where this Name has values.
For example 'Name1' has values in the period from 01/01/2017 till 01/12/2017
There should be one separate area with values in this period(01/01/2017 - 01/12/2017)
The same for each Name.
!Important: Not combined Area, only separate for each name.
Is it possible to create the same in QV according to requirements?
Thanks!
you can check trellis option in dimension
see the attached.
Thank you, but it is not quite that what I need.
There should be just one x-Axis and y-Axis for both 'Names' and 'Dates' dimensions.
This dimensions have to be on the one horizontal line.
you can make it horizontal as well/ Or else can you sketch the graph you need?
There should be just one x-Axis and y-Axis for both 'Names' and 'Dates' dimensions.
In your file we may see three x-Axis and three y-Axis.
Please look at the example image.
Dates and values is not exactly the same as in QV file.
It's just for visualization.
Thx.
something like this?
Thank you for your time but I have to say again the most general in this issue:
There should be just one x-Axis and y-Axis for both 'Names' and 'Dates' dimensions.
We can't use "Trellis" option in this case.