How to convert BarChart to BlockChart ?

[yanivvl0]

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 ?

[Chanty4u]

can u share sample app?

[yanivvl0]

here it is , Similar to the first example :

thanks.

[Chanty4u]

is this?

[yanivvl0]

no Chanty , I NEED SOMETHING THAT LOOKS SIMPLE LIKE :

NOT COMPLICATE LIKE ( years of regular )  :

- 1 BlockChart - 2 parts ONLY .

[Kushal_Chawda · Accepted solution]

like this?

[sunny_talwar]

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

[Kushal_Chawda]

sunindia

looks like you love the PICK function

[Kushal_Chawda]

[sunny_talwar]

I have been using it more often then not for situations like these ever since I have learnt their use from you Kush‌