Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Forum! 🙂
Background info:
Table 1: For scatter chart position and x and y expressions
Name, y-pos, x-pos
Alfa, 10, 5
Beta, 5, 15
Gamma, 15, 12
Table 2: Data transactions
Name, value
Alfa, 1
Alfa, 2
Alfa, 6
Beta, 1
Beta, 1
Gamma, 1
The Z expression is sum(values) - and all this in a scatter chart.
Questions:
1. In the dimension I would like the name AND value to show in the scatter chart. Is this possible?
Example: "Alfa - 9", "Beta - 2", "Gamma - 1" some like =Name & aggr(sum(value))
2. I tried just getting the sum of the values first and show in the legend; tried this =aggr(sum(value)) - why doesnt this work?
3. Under text format, how do you make the font size bigger in a scatter chart?
(I am currently in 9.0 QV)
Tobbe,
1. The expression of calculated dimension is like this:
=aggr(Name & ' value=' & sum(value), Name)
2. You have to tell by what dimension to aggregate. It should be by Name in your case (bold above)
3. Font - use Font buttons on "Axes" tab in chart properties, not the "Font tab.
An example is attached.
Tobbe,
1. The expression of calculated dimension is like this:
=aggr(Name & ' value=' & sum(value), Name)
2. You have to tell by what dimension to aggregate. It should be by Name in your case (bold above)
3. Font - use Font buttons on "Axes" tab in chart properties, not the "Font tab.
An example is attached.
Thanks for a speedy reply Michael!
1 + 2 works great, but the third question - I think perhaps I didnt explain myself well enough.
In the axes tab I can only change the font size/formatting for the X and Y values(?).
But I would like to change the dimension font size to be bold and perhaps a bit bigger. Cant find how to do this under the axes tab - could you assist further?
Again - thanks! /Tobbe.
Sorry, you mean the legend font?
If yes, go to the Presentation tab, and find "Settings..." button under the "Show Legend" checkbox. There is "Font" there too.
If you mean font size in pop-up - I don't know if you can change font there at all.
Yep, thanks again Michael!