Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Draw a line between two calculated fields

Hi Experts

Pls find the attached dashboard and expected dashboard, below table is the source file for the dashboard.

Year /QuarterProductPrice
201001LAPTOP24000
201001LAPTOP23450
201001LAPTOP21455
201001LAPTOP63221
201001LAPTOP67634
201001LAPTOP14335
201001LAPTOP67533
201001LAPTOP15457
201002LAPTOP44275
201002LAPTOP35432
201002LAPTOP55842
201002LAPTOP95657
201002LAPTOP45423
201002LAPTOP34765
201002LAPTOP35462
201003LAPTOP87674
201003LAPTOP85645
201003LAPTOP53644
201003LAPTOP54343
201003LAPTOP46242
201003LAPTOP45467
201003LAPTOP46442
201003LAPTOP43323
201003LAPTOP65623
201003LAPTOP57656


I am taking year / Quarter field on x-axis and Count(product) on y-axis (which will be in BAR CHART)

In my example I have added two more calculated fields in expression tab.

Count(product)+5 and Count(product)-5. (Which will be Symbol in display option).

Now I want to draw a line in between Count(Product)+5 and Count(product)-5. pls see the attached screenshot for clarification.

So how to achieve this to draw a line between these two calculated fields.

Thanks,

15 Replies
hdonald
Creator
Creator

Hi,

How about dropping an error bar down from the top expression ? Make it = Count(product)+10 and it should cover the gap ?

Regards,

HD

Not applicable
Author

No, its not working..

Thanks,

hdonald
Creator
Creator

My mistake...just make the Error Below = 10

Not applicable
Author

HD, I believe I have mentioned clearly what I required.

I need veritical line not horizontal line and it should be between two values that count(product)+5 and Count(product)-5.

Thanks,

Not applicable
Author

Hi Experts,

Any idea on this question?

Thanks,

hdonald
Creator
Creator

Error bars are, mostly, vertical.....

Not applicable
Author

Hi HD,

I am struggling to get this done, pls let me know what is the properties should I need to select for Count(product)+5 and Count(product)-5.

pls guide me.

Thanks,

hdonald
Creator
Creator

In the Expressions tab select the Count(Product) expression and tick the 'Has Error Bars' tick box.

Click on the '+' next to that expression and select an error bar e.g. 'Error Symmetric' and make the definition =5 (or select one of the other error bars and try different definitions to get the particular effect you want).

You can add conditional logic in the definition to control when the bars appear.

On the Presentation tab you can control the width and colour of the Error bars which can make them blend in a bit more and also fiddle with the default symbol size to make then line up with the error bar ending.

Using Error bars like this on expressions for emphasis or to get reference lines on the x-axis is an old Excel chart trick.

I'm not able to upload qvw files at the moment so I hope this is enough description,

Regards,

HD



Not applicable
Author

Thanks HD, it really helps me a lot..

Thanks,