Forum Discussion

spandy34's avatar
spandy34
Icon for Responsive Resident rankResponsive Resident
3 years ago
Solved

Continuous Date Table

I have a date table with a MIndex field as outlined below.  I want to be able to plot a line graph that goes from June 2022 to todate based on month.   How do I stop all the May , June , July etc f...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    spandy34 , Create sort column and mark that as the sort column

     

    month year sort = year([Date])*100 + month([Date])

     

    Click on month year and the in the "column tools" uses sort by column and mark month year sort as a sort column

     

    How to Create Sort Column and Solve Related Errors:
    https://www.youtube.com/watch?v=KK1zu4MBb-c

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

spandy34 , Create sort column and mark that as the sort column

 

month year sort = year([Date])*100 + month([Date])

 

Click on month year and the in the "column tools" uses sort by column and mark month year sort as a sort column

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

 

 

  • spandy34's avatar
    spandy34
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    Hi thats created the column great - i have selected the month year sort column then selected as a sort as below but I am still getting the result in the table below.  What am i doing wrong please?

     

     

     

  • spandy34's avatar
    spandy34
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    Ive sorted it - I really appreciate your help

     

    THank you