Forum Discussion
Solved
Counting (and graphing) dates over time
I am trying to count activation dates over time. The totals are correct, but I cannot get it to show activations per month. I created a measurement- Site Activations, which works, however I canno...
Hi aw3w2
If you're seeing a blank period that is most likely because your calendar table does not cover the dates in your fact table or you have a data type mismatch (datetime vs date). The column format in the designer does not matter but ensure you're using the same data types. You should be able to successfully do that in the query editor.
Hi aw3w2
If you're seeing a blank period that is most likely because your calendar table does not cover the dates in your fact table or you have a data type mismatch (datetime vs date). The column format in the designer does not matter but ensure you're using the same data types. You should be able to successfully do that in the query editor.