Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to group date using a week End Date column ?

Hi Community,

 

I have a column that is Date data type . I want to create Start Date and End Date using the same Column . Here , I want Start Date and End date to be Previous Week Monday and Current Week Monday . 

 

I created 2 Calculated columns  as shown below  . 

 

Week Start Date = SSPR[ActivityDateTime] - WEEKDAY( SSPR[ActivityDateTime],2 ) + 1
Week End Date = SSPR[ActivityDateTime] + 8 - WEEKDAY( SSPR[ActivityDateTime],2 )
 
I am getting the dates properly as shown below in screen shot. 
 
 
Now, i want to group data by Week End Date and do a count of rows to show them in Stacked column chart  . When i do that , I am getting a visual like shown below. The dates in X-Axis are not coming correctly . They are showing dates of Sundays of every week. But I want to show the Mondays which is Week End date of every week . 
 
 
Kindly help . 
 
G Venkatesh 
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 
    The group bin feature for data column will group based on the whole date. Try change the date type to Text, create groups with the text date in the x-axis.

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , are you using weekend date column on the x-axis. I doubt that. Because date is not same.

     

    Also, make sure the axis is categorical

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Amit,

       

      Yes I have created group(bins) based on Weekend Date as Direct Column of Weekend Date is not grouping data . When I add the new column based of Grouped bins Weekend date, thats where dates appeared differently. 

       

      Yes I have turned the Axis type from Continous to Categorical. 

       

      Thanks,

      G Venkatesh 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 
    The group bin feature for data column will group based on the whole date. Try change the date type to Text, create groups with the text date in the x-axis.

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.