4 Replies Latest reply on Oct 15, 2019 7:25 AM by Ken Flerlage

Group and sorted display of Set data (Workout Wednesday week 41)

Sumati Gaur Oct 12, 2019 11:24 AM

Hi Community

I am trying to solve the workoutwednesday2019 problem set : Which customers are costing us most? - Requirement to select customers from profit to weighted discount scatter plat and -rearrange-highlight the details in the adjacent table

I am able to work thorough the problem statement but totally lost on how to group the data and show it in the top rows of the table.

What I need help on :

1. Arrangement of data: The In/Out of set as column is not needed but on removing it the selected rows gets distributed as per data source order.I want to keep all set data on top of table.

Please share how these can be done

2. How to do the cohort analysis for the in set data. I know how to do it when set elements/data is fixed. No idea how it works in dynamic set.

Thank you in advance

1. Re: Group and sorted display of Set data (Workout Wednesday week 41)

Ken Flerlage Oct 12, 2019 11:28 AM (in response to Sumati Gaur)

For your first question, I think you just need to leave the set on the rows shelf but turn off the header. I'm assuming you have something like this:
Right click on the IN/OUT pill and deselect "Show Header"
I'm not sure what you mean in your second question. Can you clarify the requirement?
Like Show 0 Likes(0)

Actions
2. Re: Group and sorted display of Set data (Workout Wednesday week 41)

Ken Flerlage Oct 12, 2019 11:32 AM (in response to Ken Flerlage)
I just looked at the WW site and think I see what you mean now--are you asking how you can total up those selected items into just one single "Cohort" item? If so, try creating a calculated field like this:

Customer or Cohort
// If in the set, condense into "Cohort". Else customer name. IF [Top Customers by Profit] THEN "Cohort" ELSE [Customer Name] END

Then build your table like this:
Then turn off the header for IN/OUT.
Like Show 0 Likes(0)

Actions
3. Re: Group and sorted display of Set data (Workout Wednesday week 41)

Sumati Gaur Oct 15, 2019 7:20 AM (in response to Ken Flerlage)

Hi Ken Flerlage .Thanks a lot. This was exactly what i was stuck with. Its working for me now
Like Show 0 Likes(0)

Actions
4. Re: Group and sorted display of Set data (Workout Wednesday week 41)

Ken Flerlage Oct 15, 2019 7:25 AM (in response to Sumati Gaur)

Great. Glad to hear it!
Like Show 0 Likes(0)

Actions