Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi to all ,
i have usual BarChart with year dimension and 2 measurs, looks like that :
i need to convert it to BlockChart , with 2 parts with the 2 colors blue and green ( i dont need to see the year )
, how can i do this ? thanks ?
can u share sample app?
here it is , Similar to the first example :
thanks.
is this?
no Chanty , I NEED SOMETHING THAT LOOKS SIMPLE LIKE :
NOT COMPLICATE LIKE ( years of regular ) :
- 1 BlockChart - 2 parts ONLY .
like this?
In addition, if you would like to make selection in one of those blocks, then ValueList() as dimension won't work, in that case you can create an Island Inline table in the script and use that as your dimension:
Table:
LOAD year,
regular,
amazing,
amount
FROM
Community_211021.xls
(biff, embedded labels, table is Sheet1$);
Dim:
LOAD * Inline [
Dim
1
2
];
Dimension: Dim
Expression: (Same as what Kush has provided) just using Dim
=Pick(Dim,
Sum({$<regular={1}>}amount),
Sum({$<amazing={1}>}amount))
If not selection would be necessary you should be good using Kush's solution
looks like you love the PICK function
I have been using it more often then not for situations like these ever since I have learnt their use from you Kush