Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Can one display in line chart 'actual vs estimate hrs' above one line only ?
Can someone suggest some techniques?
Waiting for your response.
Thanks
Geeta
hi,
Yes you can achieve this.
Create a separate expression to get your desired values.. and then uncheck the option for line or bar and check option for values on data point,
HTH
Sushil
Hi Geeta,
As you haven't provided sample data, I am creating a sample application to help.. You need to change accordingly.
Use below script
Load * Inline
[
Date, Actual Sales, Estimated Sales
01/01/2015, 100, 110
02/01/2015, 120, 90
03/01/2015, 75, 90
04/01/2015, 120, 120
];
Create a Line Chart
Dimension
Date
Expression
Dual(SUM([Actual Sales])&'/'&SUM([Estimated Sales]), SUM([Actual Sales]))
Hope this would help.
Hi ,
Thanks for the Response.
Geeta