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 contains a simple date and I would like to have a "Created vs Closed" kind of graf but it does not add up. If I look at the raw data for a specifik date for each column, I can see the count beeing incorrect in the graph (bar graph at the moment).

 

My problem is most likely that I don't understand what field/value to put for the axis. I might need a new table/comlumn that combines the date from the both columns to get a correct result. But If I only use the CreatedDate as the axis it still counts incorrect for the MovedDate for a specific day.

 

ExampleData:

CreatedDate

2018-03-13

2018-03-09

2018-03-13

2018-03-08

2018-03-13

2018-03-08

2018-03-09

 

MovedDate

2018-03-13

2018-03-09

2018-03-13

2018-03-13

2018-03-13

2018-03-11

2018-03-09

 

Which gives me graph where MovedDate bars are never higher than CreateDate bar which is incorrect. And no values for 2018-03-11, which would be nice!

Does anyone have any ideas for what I am missing? 
I might be able to extract the data into excel if that would help!

 

Kind regards, Johan

Need Help

11 Replies

  • 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