can't graph by month

user06299

Why does the graph by option (day, month, year, etc) not always available? It just says none and cannot be changed. I'm using a date dimension in my X axis (YYYY-MM-DD) and numeric in my Y axis. What am I missing? I've never had this issue before.

 

 

Valiant

Does your date dimension have the calendar icon next to the name? Or is it being seen as a Text field?

 

You can also try creating a BeastMode using your date like this:

CAST( `Date` AS Date`)

Hope this helps,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

user06299

Thanks for the speedy reply. Yep, it does show the date icon that you pointed out. 

Valiant

If you recreate the card from scratch, are you still unable to group? I've had to do that before to "re-enable" some of the default options that should be available.

user06299

Tried a couple times to start from scratch. No luck. Thanks for trying

AS

Is that a drill path card or a top level card?  I've seen this behavior when it's a drill down, and we had to start that card from scratch in order to get it to work.  If it's a drill down, what date grain does the top level card have?

user09742

Uncheck hide date on card details