Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
No, its not working..
Thanks,
My mistake...just make the Error Below = 10
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,
Hi Experts,
Any idea on this question?
Thanks,
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,
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
Thanks HD, it really helps me a lot..
Thanks,