I’m creating a weekly dashboard to count how many workers turned from normal into resignation status and sort them into three types: resigning the next 2 week，1 month and 3 months.
I only got the 4 columns in the raw data 1）team，2）worker name，3）week number and 4）worker’s weekly status（ “Normal”, “resign in 2 weeks”，“resign in 4 weeks”，“resign in 12 weeks”）.
So I created a calculated filed to transfer the status into Integer type where Normal==1，resign 2weeks ==2 and so on. Then with the integers I created another calculated filed with the formula below to locate the status turning point in the week&worker level:
But the filed can‘t be used as a dimension, so I can’t use it to count the numbers in the team&week level. The error alert is “Custom aggregation fileds is not allowed as a dimension”
Dear friends, are there any solutions to solve this problem? Please let me know，Many thanks!