Forum Discussion

tommy_g's avatar
tommy_g
Icon for Helper V rankHelper V
4 years ago
Solved

Need help with Insights

I keep coming up empty when looking for insights. I need an informed opinion (aka "insight") on the following line from the official documentation:   "Anomalies and trends are only supported for bu...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi tommy_g 


    The way I understand it is that either it has to use the builtin time hierarchy, which I agree I dont use. Or you have to have a column that is datetime and not just date for it to work.

tommy_g's avatar
tommy_g
Icon for Helper V rankHelper V
4 years ago

You are correct, Date-Time is required. 

 

We are reporting on a monthly granularity for the high volume facts. So I changed my Report Month field, previousky forced as yyyy-mm-01 to to a DateTime column and the insights appeared. Mercifully, they did not mention that a whole lot of stuff happens at 12:00:00 AM.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
4 years ago

Thanks for the confirmation!