Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can i get my text on axis values to line u with the bars in the chart?
The cart has 2 expressions with one bar hidden (the one that has the text on the axis)
can i align this with the first expression?
CURRENT
WHAT I WANT
Write the single Expression:
=Dual( COUNT(DISTINCT S_ID) &'-'& num((COUNT(DISTINCT S_ID)/COUNT(DISTINCT TOTAL S_ID)),'#0.00%'),
COUNT(DISTINCT S_ID))
Check the Value on Data point
use calculated dimension with COUNT(DISTINCT S_ID)/COUNT(DISTINCT TOTAL S_ID)
and your expresion will be COUNT(DISTINCT S_ID)
If you have two expressions then the text-on-axis will be aligned with its own expression, not the other one. But perhaps you can use a combi chart and use Symbol as representation type for the second expression and set the background color of the symbol to a totally transparent color like red(0).
This is giving me both values on each point
i want % on axis and total on data point
If you have Text on axis expression then just click on + sign and Give text color expression as Black() or red()
I mean i want it to look like this...
See attached example.
I'm using the personal edition and am unable to view this file. Can the solution be explained?
Perhaps this helps: