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 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,
Nope, I got the solution.
Thanks,
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,
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
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
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