Weekdays as name for the column

soncoku · 2020-06-08T12:59:48+00:00

I have a table with records like below: IDDATERevenueDay5001 01-06-2020 20Monday500106-06-202025Saturday500408-06-202024Monday500408-06-202022Monday500414-06-202036Sunday What I want to achieve is this: Using the filter to automatically get the data of current week and then get the result like below IDRevenuePeriod…

soncoku

I have a table with records like below:

ID	DATE	Revenue	Day
5001	01-06-2020	20	Monday
5001	06-06-2020	25	Saturday
5004	08-06-2020	24	Monday
5004	08-06-2020	22	Monday
5004	14-06-2020	36	Sunday

What I want to achieve is this:

Using the filter to automatically get the data of current week and then get the result like below

ID	Revenue	Period
5004	82	08.14-06-2020

08 == Monday of this week

14 == Sunday of this week

06 == month

20 == year

Any suggestions?

Date Time

Accepted answers

bhrmitra

Hi soncoku,

I hope I have understood your problem statement correctly.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

Weekdays as name for the column - Abhra Mitra - Solution.yxmd

bhrmitra

Hi soncoku,

I've attached my workflow for you to download. If this solves your issue please mark the answer as correct and also hit the like button, if not let me know!

Thanks,

Abhra Mitra

Weekdays as name for the column2 - Abhra Mitra - Solution.yxmd

All comments

MarqueeCrew

@soncoku ,

if you filter by day = "Monday", you could sort on date descending. Then you could sample the first 1 records. Using an append fields Tool, is is possible to spend the date to each of the original records as Date2.

Now you can filter on date >= date2.

summarize by id and sum revenue and you're done!

Cheers,

mark

bhrmitra

Hi soncoku,

I hope I have understood your problem statement correctly.

If this solves your issue please mark the answer as correct and also hit the like button, if not let me know! I've attached my workflow for you to download if needed.

Thanks,

Abhra Mitra

Weekdays as name for the column - Abhra Mitra - Solution.yxmd

soncoku

that's perfect.

Now I've taken another workflow to another level.

ID	MONDAY	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY	SATURDAY	SUNDAY
5001	200	20	50	0	0	60	90
5002	300	40	50	20	25	65	10
5003	690	55	70	80	10	10	60

i HAVE THAT

And I want to achieve this:

ID	Revenue	Period
5001	420	08.14-06-2020
5002	510	08.14-06-2020

I only have the weekdays, but the values on the weekdays are always this weeks data.

So I need something that get's the current week and finds whats the date for Monday an Sunday for this week

For example :

Monday == 08

Sunday == 14

So that last column would have 08.14-06-2020

Do you think you could help me this too?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703