Forum Discussion
Date Slider Not Handling Years Correctly
parry2kThanks! I created a date table following this set of instructions.
From here, what is the best practice/ what do you recommend?
Should I still create a "Month Sort" column based off of my new date column?
Shouhld I just manage the relationships and then use the date column from the new date table in my visuals?
Just want to make sure I'm setting everything up in the best way :)
Super UserAnonymous beautiful, you are on right track.
Now set the relationship between your new date table and your transaction table. Do month sort in your date table and use month from date table in your visuals.
Assume you don't have date fields in your transaction table (just hide those) and anything related to time intelligence use fields from date table.
Good luck!!
parry2kApologies! I am getting some funky results -- this is probably intuitive for most, but just to clarify, here's what I did:
-The "Month Sort" column is in the transaction table and it is based on my "Milestone Date" column from the transaction table-I linked the transaction table and date table in relationships. I connected the "Milestone Date" in my transaction table to my "Date" column in the date table.
-On my slicer for my visual, I put the "Date" column from my date table into the field.
Please let me know where I went wrong and what do differently. My end goal is to have a slider that correctly filters all of my visuals by the "Milestone Date".
Thank you for your patience!
- parry2k
Anonymous it is too hard to explain everything, if you are ok PM me directly and we can work on it.
parry2k I don't think it will allow me to PM you.... unless I'm missing some obvious functionality.