0

We have continuous date series data and we have to visualize week start date and week end date wise on chart, how to implement it.

My table is

enter image description here

KARTHIKEYAN.A
  • 18,210
  • 6
  • 124
  • 133
  • Can we interpret each row of the table as a participant of a survey? Is it a correct understanding that the first row represents a participant who joined the survey from August 1 to August 7, and his screen usage was 36 hours in total across 3 different days? – Kosuke Sakai Dec 09 '19 at 04:58
  • Sure will update you give sometime. What i did here is based on start date i create column i have created weekend Saturdays and its duration count. Will update actual description of table. Thanks for comment. Table altered due to understanding. – KARTHIKEYAN.A Dec 09 '19 at 05:33
  • 1
    Thanks, looking forward to seeing the description. And also, it would help visitors of this question for better understanding if you could make your question more focused. – Kosuke Sakai Dec 09 '19 at 05:58

1 Answers1

0

We can able to calculate In the following ways

Syntax : WEEKDAY(DATE,WEEK_STARTDATE_OPTION)

  1. Sunday=1 through Saturday=7
  2. Monday=1 through Sunday=7
  3. Monday=0 through Sunday=6

Week start date = MedianScreenUsagePerDay[startDate] - WEEKDAY(MedianScreenUsagePerDay[startDate],1)

Week end date = MedianScreenUsagePerDay[startDate] - WEEKDAY(MedianScreenUsagePerDay[startDate],1) + 7

After created new Week ending Saturdays column

enter image description here

Week ending Saturdays, we are displaying through ribbon chart

enter image description here

KARTHIKEYAN.A
  • 18,210
  • 6
  • 124
  • 133