nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Scatter plot using crosstab columns

trespass78

Hi all,
 
I need your help to build a scatter plot using two Crosstab columns.
What I did is to import and excel file (called "dati.xls", attached) composed by the following columns:
 
<div>x y z</div>
<div>a 1 123</div>
<div>a 2 32</div>
<div>a 3 432</div>
<div>b 4 54</div>
<div>b 5 6</div>
<div>c 6 1</div>
<div>c 7 23</div>
then I built a cube as
 
X aggregation level dimension
Y and Z two measures aggregated on X
 
then I built a crosstab and a scatter plot as shown in pic1 (attached).
 
What I have to do is a simple scatter plot using "Y" crosstab column as y-axes and "Z" crosstab column as x-axes without aggregating on "Z" (a simple line).
 
The shown preview is correct, it is what I want to plot, but when I run the report it gives to me a null pointer exception, I think it is unable to find "Z" values over the crosstab.
 
Could you please help me?
 
thanks and regards,
 
Massimo

Find more posts tagged with

Comments

mwilliams

It doesn't like using both measures. If you choose a measure for the y-axis, the category x is automatically chosen for the x-axis.
 
Have you tried using a table grouped by x with aggregations for y and z in the group header, then use the table as your chart source instead? That should work. Let me know.

trespass78

Hi Michael,
 
thanks so much for your support.
Yes, using a "table" object it works correctly, but I have to use a "crosstab" (if it is possible, at that point).
Do you think it is not feasible a "crosstab" solution at all?
 
regards,
 
Massimo

mwilliams

Sorry for the delay. Why must you use the crosstab? Is it for display purposes? if so, you can display the crosstab still and just hide the table. Let me know.