Forum Discussion

tommy_g's avatar
tommy_g
Helper 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.

GilbertQ's avatar
GilbertQ
Super User
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
    Helper 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
      Super User
      4 years ago

      Thanks for the confirmation!

  • tommy_g's avatar
    tommy_g
    Helper V
    4 years ago

    Rated Four Moos!