Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am looking to transform some of our data, but without access to the dataload sections, so all have to be done as expressions...
We have a dataset where we have a category field which has the numbers 1 - 8, 15, 18-20.
The data I have I want to split into the following rows and add columns on other fields (Country + Gender)
- All categories
- Category 1-8
- Category 5,7,8
- Category 4
- Category 3
- Category 2
Category 1,2,6
In addition in the Country column I want to list each Country, but also add a "Company Total" summation...
Simplified datamodel is like this:
| UserID | Country | Gender | Category |
| 1 | NO | M | 1 |
| 2 | SE | F | 1 |
| 3 | NO | M | 20 |
Outcome to look something like this:
Total = sum of all countries.
How do I split the percentages per row and country? I can get the numbers fine, but not the percentages split on each row.
As I can't add anythign to the loadscripts or data models, only the analysis sheets I'm a little over my head 😄
.png "Former Employee"){kind=icon}
