how can i create a category grouping in Quicksight
eg have {AUX_CONSPTN} AND {AUX_CON_MOVING} AND {TAUX_CON_SSTL} to be a field called AUX.
Thanks
Do you want the values in {AUX_CONSPTN} AND {AUX_CON_MOVING} AND {TAUX_CON_SSTL} to be put into one column?
If {AUX_CONSPTN} = a
{AUX_CON_MOVING} = b
{TAUX_CON_SSTL} = c
you can use concat({AUX_CONSPTN}, “:”, {AUX_CON_MOVING}, “:”, {TAUX_CON_SSTL})
to return {AUX} = a:b:c
what i want to do is to create a category for AUX which would have all the values of all the aux field (AUX_CONSPTN,AUX_CON_MOVING,AUX_CON_SSTL) summed up.
Depending on your use case, this should work for you:
sum({AUX_CONSPTN}) + sum({AUX_CON_MOVING}) + sum({TAUX_CON_SSTL})
If this isn’t, please provide what visual you are trying to utilize, as well as your groupings and data structure.
This is what I need,
(AUX_CONSPTN AUX_CON_MOVING AUX_CON_SSTL) all in one bucket as Auxiliary.
Thanks
Hi @olusegun83 ,
Create a calculated field using ifelse ?
Another example : https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Derived-Categories
Regards,
Koushik