Forum Discussion
Sort by Column does not work
Hi Sky,
I think you still be able to solve this issue if you change the name of your attribution month groups as 00-01 momth AR, 02-03 monthAR, 04-13 month AR, 13-25 month AR and 25+ month AR and then you can directly sort it by Attrition Month Group.
Regards,
Sarita
Did you apply this step:
4) Go to the modelling tab and select sort by attribution month.
Select Attrition Month Group From Fields Panel and Go to Modeling Sort by Column (AttritionMonthText)
Thanks for reply Vvelarde. I get the error below, when I try to sort by attrition month text :
We can't sort the 'Attrition Month Group" column by 'AttritionMonthText'. There can't be more than one value in 'AttriionMonthText' for the same value in 'Attrition Month Group'. Please choose a different column for sorting or update the data in 'AttritionMonthText'.
It is all about grouping, so obviously there are more than one value (month) in AttritionMonth associated to a Attrition Month Group! Not sure what can be done to get the results of group sorted ....
Hi Sky,
I think you still be able to solve this issue if you change the name of your attribution month groups as 00-01 momth AR, 02-03 monthAR, 04-13 month AR, 13-25 month AR and 25+ month AR and then you can directly sort it by Attrition Month Group.
Regards,
Sarita
Thanks Sarita. I followed your later suggestion and sorted based on Attrition Month Group directly. It doesn't look nice to have 0 before the numbers, but at least the result is now sorted right. Thanks for your help :)
Hi Sky,
If you want it too look as what you wanted, you can create a relationship table for the month group . Connect it to your fact table and it will give you an outcome like this
