Draw a line between two calculated fields

[#1]

Hi Experts

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

Year /Quarter	Product	Price
201001	LAPTOP	24000
201001	LAPTOP	23450
201001	LAPTOP	21455
201001	LAPTOP	63221
201001	LAPTOP	67634
201001	LAPTOP	14335
201001	LAPTOP	67533
201001	LAPTOP	15457
201002	LAPTOP	44275
201002	LAPTOP	35432
201002	LAPTOP	55842
201002	LAPTOP	95657
201002	LAPTOP	45423
201002	LAPTOP	34765
201002	LAPTOP	35462
201003	LAPTOP	87674
201003	LAPTOP	85645
201003	LAPTOP	53644
201003	LAPTOP	54343
201003	LAPTOP	46242
201003	LAPTOP	45467
201003	LAPTOP	46442
201003	LAPTOP	43323
201003	LAPTOP	65623
201003	LAPTOP	57656

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,

[#2]

Hi HD, there is one more issue has come,

when I select particular year, the error bars values end out of the chart scale.

Do you have any option to select the error bars value should not out.

Thanks,

[#3]

Nope, I got the solution.

Thanks,

[#4]

Hi HD,

I would like put one message in the BAR chart.

Condition is : If Count(Product)<5 then Chart should be blank with the message "No product calculation because the Count(Product)<5"

How to implement this, pls guide me.

Thanks,

[#5]

Hi tims,

You can write Your condition in "calculation condition" (in chart general tab), then in "error messages" (The same tab) option input Your message.

Enjoy

[#6]

Hi tims,

You can write Your condition in "calculation condition" (in chart general tab), then in "error messages" (The same tab) option input Your message.

Enjoy

[hdonald]

Hi,

I might try adding an 'IF' statement wrapper around your error bar expression like if(Count(Product)>=5,5) to only show the error bar if values, in a given month, are in the range you want.

Then add another expression with a similar 'IF' condition to display your error message if count <5.

Make sure this expression has no line or symbol but does have either 'Values on Data Points' or 'Values on Axis' depending on where you'd prefer the text to appear.

The presentation tab has some options to show data points inside a segment (maybe vertical) for text in bar style,

Regards,

HD