Data field value grouping

Q&A
,
1

In PowerBI i use a very useful tool that allows to create custom groups of data values. Example below.

image
image1146×905 66.2 KB

This is very useful in my use case to create analysis against groups of currency pairs or groups of funds etc.
I haven’t found any similar feature In Quicksight unless I am mistaken.
Also what would be the easiest solution to achieve this functionality.(only way I can think is manually create a calculated field with ifelse() and manually match every value to a new group value)

2

There’s no such out of the box solution in QS so your best bet is to create a calculated field as you described.

3

@Dom

as @todd.hoffman said, a calculated field is your best approach at the moment.

Something like this:
ifelse({CurrencyPair}= ‘EURAUD’, ‘Developed’,
{CurrencyPair}= ‘EURCAD’, ‘Developed’,
{CurrencyPair}= ‘EURCHF’, ‘Developed’,
{CurrencyPair}= ‘EURDKK’, ‘Developed’,
{CurrencyPair}= ‘EURGBP’, ‘Developed’,
{CurrencyPair}= ‘EURHKD’, ‘Developed’,
{CurrencyPair}= ‘EURJPY’, ‘Developed’,
{CurrencyPair}= ‘EURSGD’, ‘Developed’,
{CurrencyPair}= ‘EURUSD’, ‘Developed’,
{CurrencyPair}= ‘EURINR’, ‘NonDeveloped’,
{CurrencyPair}= ‘EURMXN’, ‘NonDeveloped’,
{CurrencyPair}= ‘EURKRW’, ‘NonDeveloped’,
{CurrencyPair}= ‘EURBRL’, ‘NonDeveloped’,
{CurrencyPair}= ‘EURTWD’, ‘NonDeveloped’,
{CurrencyPair}= ‘EURCNH’, ‘NonDeveloped’,
‘Other’)

Hope it helps,
GL

1 Like