Forum Discussion

johanhallin's avatar
johanhallin
Frequent Visitor
8 years ago

Bar Graph Troubles, incorrect values

Hi, I have search the forum but not found anything around my problem so I am hoping for some help. I have a table with many columns where two are of interest, CreatedDate and MovedDate. Both contai...
Need Help
jthomson's avatar
jthomson
Solution Sage
8 years ago

Not sure exactly what you're trying to do, but if you're playing with multiple date fields then you really, really need a calendar table to use as your axis

  • johanhallin's avatar
    johanhallin
    Frequent Visitor
    8 years ago

    That sounds like my problem...so...I should create a seperate table as a calendar? What do I fill in in that new table? A outerjoin of the two columns of some sort?

     

    Any guidlines?

     

    //Johan

    • johanhallin's avatar
      johanhallin
      Frequent Visitor
      8 years ago

      Ok, so I managed to create a new table for the date calender using Date = CALENDAR (DATE(2016;1;1); DATE(2020;12;31)).

      But I'm still not given any resonable bar graph. Not it displayes the total count for created date as a flat line for all dates....not "per date" as I want it to be...

       

      I am surley missing something easy and basic but I can't figure out what. 

      I have tried adding a relationship to my new table as well...no difference...

      //johan

      • jthomson's avatar
        jthomson
        Solution Sage
        8 years ago

        You need to make relationships between the calendar table and your date field(s)