For each week, keep 1 number and have 0 as the rest.

[wonka1234]

Hi,

I have a number for each day of a week, but i want to not replicate the number and just have it show once for the week. Ie not aggregate per week.

current data:

Date	DOW	Week	RecordID	placeholder
1/30/2023	Monday	1/30/2023	1355	3
1/31/2023	Tuesday	1/30/2023	1355	3
2/1/2023	Wednesday	1/30/2023	1355	3
2/2/2023	Thursday	1/30/2023	1355	3
2/3/2023	Friday	1/30/2023	1355	3

expected:

Date	DOW	Week	RecordID	placeholder
1/30/2023	Monday	1/30/2023	1355	3
1/31/2023	Tuesday	1/30/2023	1355	0
2/1/2023	Wednesday	1/30/2023	1355	0
2/2/2023	Thursday	1/30/2023	1355	0
2/3/2023	Friday	1/30/2023	1355	0

Note that there are more "date" and "week"  with different "record id" this is just a sample.

hoping this makes sense.

[Luke_C]

Hi @wonka1234 

How is this fact pattern different than the other post you have? The same solution (or slight variation of it) should work

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Make-column-B-0-for-all-but-1-...

[danilang]

Hi @wonka1234 

Do you want a single placeholder per week and ID or just week?

Does your week start on Monday or Sunday

Dan 

[wonka1234]

@danilang @Luke_C  week starts monday and goes to friday.

single placeholder per week and ID.

I came up with this from previous post - but unsure it does by week and ID..

multi row -  if isnull([Row-1:Week]) or [Week] != [Row-1:Week] then [placeholder] else 0 endif

[danilang]

@wonka1234 

This certainly looks like it will work.  Are the results correct when you try with your actual data?

Dan

[hlee36]

Hi @wonka1234 

I would use "Tile" tool and make the "week" column as unique value in the tile configuration.

Then, we can use a formula to convert the value of 1 in the tile number sequence into [placeholder] and other values into 0.