Forum Discussion

paulwozniak's avatar
paulwozniak
Icon for Helper I rankHelper I
10 years ago
Solved

Google Analytics - date slicer only has year

I have Google Analytics set up as the only source. I have a date field, the page field and the pageviews field imported.   When I create a slicer visualization and drag the date field into it, it o...
  • pqian's avatar
    pqian
    10 years ago

    Phil_Seamark, I think what paulwozniak wants is hierarchical slicers (vs individual values), which isn't available today.

     

    You can goto the Queries Editor, and bring Month and Day of the Month dimensions in from the Time folder. They won't affect your filters on ga:date.

     

    Alternatively, you can add a calculated column with things like MONTH([date])

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

That's because you are still using the automatic date hierarchy. In the image you posted. Click the line above Date Hierarchy. So make sure the green tick is next to "Date"

pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Phil_Seamark, I think what paulwozniak wants is hierarchical slicers (vs individual values), which isn't available today.

 

You can goto the Queries Editor, and bring Month and Day of the Month dimensions in from the Time folder. They won't affect your filters on ga:date.

 

Alternatively, you can add a calculated column with things like MONTH([date])