How to display on weekdays of data into Table and Visualization | Community
Skip to main content
PradeepJaiswal
PradeepJaiswal
Level 3
July 4, 2017
Solved

How to display on weekdays of data into Table and Visualization

  • July 4, 2017
  • 8 replies
  • 5025 views

I am working on login event and login error table, most of the traffic is on weekdays. I would like to hide/remove the weekend data from my table and the visualization. How do i achieve that? I created one segment pqr using the dimension xyz where xyz=monday or tuesday or etc... However breakdown of pqr followed by dates still display the weekend data(though count is zero) after using pqr breakdown.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by EricMatisoff

    Another option would be to use a custom Time Parting variable (you may already have a prop or eVar set aside for this) and then classify Weekday/Weekend. We had a similar idea presented at our Analytics Idol breakout session at Summit where in addition to Weekend, the presenter also classified days that weren't business days (like holidays). Check out the second idea described by Rob Adams here: Analytics Idol 2017 In Review | Adobe

    Hope that helps!

    8 replies

    PradeepJaiswal
    PradeepJaiswalAuthor
    Level 3
    July 4, 2017

    How do i attach image file to the question ?

    R
    RameshAnalytics
    Level 4
    July 5, 2017

    Hi Pradeep,

    Drag 'Day' from dimension (select only weekday's from day dimension) and add the metrics you want to show. (see the below screenshot). Hope It helps.

      PradeepJaiswal
      PradeepJaiswalAuthor
      Level 3
      July 7, 2017

      1) How did u add image to your comment? I was not able to do so.

      2) Sorry I forgot to tell you, Days are the breakdown rows in my table, it would be a month data so i wont be able to drag 20 weekdays into column. Can we create any segment or something by which only weekdays are displayed into rows during the breakdown ?

      TanmayMathur
      Adobe Employee
      TanmayMathurAdobe Employee
      Adobe Employee
      July 10, 2017

      Hi Pradeep,

      In the reply editor you will see an 'Insert image' option on the top. Click on that and you will be able to add the image in your comment.

      R
      RameshAnalytics
      Level 4
      July 10, 2017

      Hi Pradeep,

      You can add segment to exclude weekend days for that Month (See the screenshot) and it shows only weekdays total for that Month.

      PradeepJaiswal
      PradeepJaiswalAuthor
      Level 3
      July 10, 2017

      I did try this approach, but the problem of having 0 count in the table is that, it would display the drop in the trend report on weekend. It may deviate the focus/purpose of the visualization. I wanted visualization to only display weekdays of data trend, as we already know that traffic is very less on weekend.

      R
      RameshAnalytics
      Level 4
      July 10, 2017

      Hi Pradeep,

      Ok, If you want to show only weekdays with out any weekend (in rows as empty) then I guess you need to drag weekdays 'Day' to rows from that Month (OR) Create segment to add only weekdays as 'Day' from that Month.

      EricMatisoff
      Adobe Employee
      EricMatisoffAdobe EmployeeAccepted solution
      Adobe Employee
      July 10, 2017

      Another option would be to use a custom Time Parting variable (you may already have a prop or eVar set aside for this) and then classify Weekday/Weekend. We had a similar idea presented at our Analytics Idol breakout session at Summit where in addition to Weekend, the presenter also classified days that weren't business days (like holidays). Check out the second idea described by Rob Adams here: Analytics Idol 2017 In Review | Adobe

      Hope that helps!

        H
        Adobe Employee
        Here2Learn2Adobe Employee
        Adobe Employee
        September 8, 2023

        Hi @ericmatisoff the link you posted here doesn't work anymore - I'm interested in seeing if this is something I can do for my client. I'd like to be able to have a visualization that omits weekends all together - so you don't see the drop off for my client who is a bank for business accounts and therefore having 0 traffic on weekends ruins the visual representation of their peaks and valleys of traffic. 

        EricMatisoff
        Adobe Employee
        EricMatisoffAdobe Employee
        Adobe Employee
        September 8, 2023

        You should be able to find it here: https://adobe.ly/aarockstartips 

          Terms & ConditionsAccessibility statement

          Loading footer...