Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Folks,
I want to create a line Graph , below are the requirements:
X-Axis
Dec-14 to Dec-15
YTD-15
Y-Axis
0 % - 100 %
Data
% ECO Due of Active ECOs --> For this I do have expression so I can use it
YTD-15
Target % ECO Due of Active ECOs --> Target need to be set as 25% , can do by using reference lines
Kindly help here.
Thanks,
AS
Amit,
For your target line add a new expression with: =0.25
Then you can set its color and line type.
Marc.
Marc,
Target and % ECO Due of Active ECOs is not an issue , struggling with X-axis from dec14 till dec 15 and Y-axis issue.
Thanks,
AS
Amit,
If you need this limits for dimension, type this as a calculated dimension:
=if(yourdatefield>='20141201 and yourdatefield<='201512', monthstart(yourdatefield))
I don't know exactly what are you asking for y-axis. If the issue is make it %, then select Relative checkbox in expression tab, or go to number tab and select %.
Hope it helps.
Marc.
Sorry not working
Amit,
I can not help further as far as I read. Could you please share a sample?
Marc.
See the attachment.
Thanks,
AS
Amit,
In your qvw you have not any relation between owners and dates. If you want to make a chart with these dimensions, you must have your data with owner-date granularity.
Once you get it, just add a dimension with Month, and that's it!
Marc.
Marc,
I do have date relation now , kindly check .
Also calling Dimension as Month , but not getting exactly what I'm looking for.
See the attachment.
Thanks,
AS
Kindly help here!