Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
4 years ago
Solved

My date table is not working,

Hi   I have sales table which comes from database. It starts from 2012. My sales table as follow     I have created a date table as follow     I connected the date table and sales...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    In the Query Editor, seperate the date and time into 2 columns.  Then create a Calendar Table from the Date column.  Create a relationship from the Date column of the data table to the Date column of the Calendar Table.  In the Calendar table, extract Year, Month name and Month number using calculated column formulas.  Sort the Month name by the month number.  To your visual, drag Year and month name from the Calendar Table.

    Hope this helps. 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

In the Query Editor, seperate the date and time into 2 columns.  Then create a Calendar Table from the Date column.  Create a relationship from the Date column of the data table to the Date column of the Calendar Table.  In the Calendar table, extract Year, Month name and Month number using calculated column formulas.  Sort the Month name by the month number.  To your visual, drag Year and month name from the Calendar Table.

Hope this helps.