Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all,
i have a excel file with dimension: Phase and want a pie chart. I want to show all 3 together like:
if(Phase='hello' and 'hi' and 'hey', 'hello')
i need some help at the expression. how can i show all 3 together in one hello??
thanks.
i have something like this:
phase
a
b
hello
hi
hey
and i want to show a pie chart with: a,b, and (hello,hi,hey) as hello
Try below as dimesnion
If(Phase='hi' or Phase='hello' or Phase='hey','hello',Phase)
or this
pick(match(Phase,'hi','hello','hey')+1,Phase,'hello','hello','hello')