2 Replies Latest reply on Sep 10, 2013 2:09 PM by caroline sui

    So far, my database only have one month data, but I still would like to generate last 12 months report. It will show 0 for months which don't have any data in database. Can it be done in Tableau?

    caroline sui

      I need a monthly report. Right now I only have one month data in the database. For example, I only have count for 2013-08 is 100. but I still would like to create a monthly report for last 12 months.

       

      Month2012-92012-102012-112012-122013-012013-022013-032013-042013-052013-062013-072013-08
      Count00000000000100

      Can it be done in tableau?  What extra data I have to add in the database, such as date dimension etc.

       

      Thanks,

      Caroline Sui