Workspace: Month Field with a Segment - Technical Problem (I THINK)

Avatar

Avatar

jeff_bloomer

Avatar

jeff_bloomer

jeff_bloomer

29-10-2020

Try this on your own and tell me it isn't frustrating.  I'm trying to use the Month field between to Freemform Tables.  I want 2018 under a segment in one and 2019 in another.  However, Workspace doesn't work this way.  For instance, if you create a Panel that spans 2018 thru 2019, then create your two segments, one for 2018 and one for 2019, you will get a Charlie Foxtrot as a result.  Instead of the months of Jan - Dec of 2018 underneath one and their respective months for 2019 in the other, it gives me 15 months for both, starting with January 2018.  CRAZINESS!

In order to get what I want, I have to create two separate panels, set the year for each and then go after the data.  The problem with this is that I cannot compare and contrast the data next to each other in graphs or otherwise.  SUPER FRUSTRATING.

jeff_bloomer_0-1603990388845.png

 

Adobe Analytics month Workspace

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

jeff_bloomer

Avatar

jeff_bloomer

jeff_bloomer

08-12-2020

@jantzen_belliston-Adobe,

Unfortunately, there is no satisfying "correct" reply that can be applied to this one, because this is a problem that cannot be fixed in the current way that Adobe Analytics currently behaves.  I played with this for more than an afternoon using all of the suggestions and was unable to produce output the way I would have preferred for it to display in the first place.  I used a workaround and moved forward.  Thanks to everyone for their efforts!

Answers (3)

Answers (3)

Avatar

Avatar

pier-olivierd92

Avatar

pier-olivierd92

pier-olivierd92

30-10-2020

Hi Jeff,

 

I would recommend defing your year just as you did (or using the year dimension), but instead of dragging the month dimension in, try using month of year. This way, you should be able to get rid of the months outside of the defined year date range.

 

Let me know if this works,

 

Pier-Olivier

Avatar

Avatar

yuhuisg

MVP

Avatar

yuhuisg

MVP

yuhuisg
MVP

02-11-2020

@jeff_bloomer , I think I've been able to replicate your tables.

Screenshot 2020-11-03 at 10.02.12 AM.png

As indicated in my screenshot's annotations, the "Month" is based on the panel's date range. For example, if I changed my date range to start from 1 Aug 2019, then I'd get this:

Screenshot 2020-11-03 at 10.11.06 AM.png

But it's worth noting that the data is still correct. Notice that only the 2019 months have non-zero numbers (which I've grayed out).

I think @pier-olivierd92's suggestion is the best option for you. But as you've noted, and as I've indicated in my first screenshot's annotation, "Month of Year" is treated as a string, and its values are added (seemingly) randomly. So if I were you, I'd do the following:

  1. Click the "Month of Year" in the left rail to show all of the month names.
  2. Drag the missing months into the table as columns.
  3. Rearrange the months to be in chronological order.

It's also worth noting that you can right-click in a metric and choose "Compare time periods" or "Add time period column" that can maybe ease your work, as @evolytics_brian suggested.

Avatar

Avatar

evolytics_brian

MVP

Avatar

evolytics_brian

MVP

evolytics_brian
MVP

29-10-2020

Hey, @jeff_bloomer ! 

Have you tried using a custom date range to specify your months? You might also be able to right-click on the metric and try the "compare time periods" option.

evolytics_brian_0-1603994758409.png

This obviously puts everything in a single table/panel, but it will let you get a side-by-side view of any two date ranges you need to compare. Is this close to what you're after?