Hi all, I have a data set in which I am trying to calc the % of total per week, and can't for the life of me figure it out. I need the % of a field that coincides to the week total for the week it belongs to. Below is an example of the data I have: WeekDayEx1Ex2Ex31Mon1020301Tue1020301Wed1020301Thu1020301Fri1020301Sat1020301Sun1020302Mon1020302Tue1020302Wed1020302Thu1020302Fri1020302Sat1020302Sun102030 I am trying to get an output like this: WeekDayEx1Ex2Ex31Mon2%5%7%1Tue2%5%7%1Wed2%5%7%1Thu2%5%7%1Fri2%5%7%1Sat2%5%7%1Sun2%5%7%2Mon2%5%7%2Tue2%5%7%2Wed2%5%7%2Thu2%5%7%2Fri2%5%7%2Sat2%5%7%2Sun2%5%7% Anyone have any suggestions? Thanks!

% of Total Per Week

Hi all,

I have a data set in which I am trying to calc the % of total per week, and can't for the life of me figure it out. I need the % of a field that coincides to the week total for the week it belongs to. Below is an example of the data I have:

Week	Day	Ex1	Ex2	Ex3
1	Mon	10	20	30
1	Tue	10	20	30
1	Wed	10	20	30
1	Thu	10	20	30
1	Fri	10	20	30
1	Sat	10	20	30
1	Sun	10	20	30
2	Mon	10	20	30
2	Tue	10	20	30
2	Wed	10	20	30
2	Thu	10	20	30
2	Fri	10	20	30
2	Sat	10	20	30
2	Sun	10	20	30

I am trying to get an output like this:

Week	Day	Ex1	Ex2	Ex3
1	Mon	2%	5%	7%
1	Tue	2%	5%	7%
1	Wed	2%	5%	7%
1	Thu	2%	5%	7%
1	Fri	2%	5%	7%
1	Sat	2%	5%	7%
1	Sun	2%	5%	7%
2	Mon	2%	5%	7%
2	Tue	2%	5%	7%
2	Wed	2%	5%	7%
2	Thu	2%	5%	7%
2	Fri	2%	5%	7%
2	Sat	2%	5%	7%
2	Sun	2%	5%	7%

Anyone have any suggestions?

Thanks!

Datasets

Reporting

Preparation

Accepted answers

afv2688

Hello @tr3nd ,

Hope this helps

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

percentage.yxmd

All comments

BrandonB

The first step is to summarize the data. Group by Week and Sum the field. Then join the data back to the original data on the week field. Then you use a formula tool to divide the value into the sum.

BrandonB

percent of week.png

percent of week.yxmd

afv2688

Hello @tr3nd ,

Hope this helps

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

percentage.yxmd

RolandSchubert

Hi @tr3nd ,

first step is to calculate the "sum by week" (use Summarize tool and group by week). Then you join the sum values to the original using the Join tool. To calculate the percentages, a Formula tool can be use. Last step is "formatting" as percentages, this needs conversion to string datatype and adding a "%" sign. I've attached a sample workflow.

Corrected calculation (percentages of total all columns, not single column)

Best,

Roland

Or as your output:

Awesome, this worked perfectly!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335