the first time i saw the video where the combo chart was used to create the stacked bar with a line i was amazed. the next evolution to that was remove the hard coding:
data:
load 'Value' & (floor(rand()*20)+1) as dim, date(today()-floor(rand()*15)) as Date, floor(rand()*1000)/100 as Amount;
load 1 as num AutoGenerate(500);
set vDim1= =subfield(concat(distinct dim,','),',',1);
set vDim2= =subfield(concat(distinct dim,','),',',2);
set vDim3= =subfield(concat(distinct dim,','),',',3);
set vDim4= =subfield(concat(distinct dim,','),',',4);
set vDim5= =subfield(concat(distinct dim,','),',',5);
set vDim6= =subfield(concat(distinct dim,','),',',6);
set vDim7= =subfield(concat(distinct dim,','),',',7);
set vDim8= =subfield(concat(distinct dim,','),',',8);
set vDim9= =subfield(concat(distinct dim,','),',',9);
set vDim10= =subfield(concat(distinct dim,','),',',10);
set vDim11= =subfield(concat(distinct dim,','),',',11);
set vDim12= =subfield(concat(distinct dim,','),',',12);
set vDim13= =subfield(concat(distinct dim,','),',',13);
set vDim14= =subfield(concat(distinct dim,','),',',14);
set vDim15= =subfield(concat(distinct dim,','),',',15);
set vDim16= =subfield(concat(distinct dim,','),',',16);
set vDim17= =subfield(concat(distinct dim,','),',',17);
set vDim18= =subfield(concat(distinct dim,','),',',18);
set vDim19= =subfield(concat(distinct dim,','),',',19);
obviously, the stack should be finite. use the dimension:
=vDim1
expression
= sum({<dim={'$(vDim1)'}>}Amount) also, add a condition =count( distinct dim)>=1
then just replicate it.
but that does not address your question. i did a combo using 20 dimensions (see attached) yes it is possible. maybe there was just a problem with your expression. i had the same problem with combo charts before and it was so easy to blame it
