Solved
Converting date column to month dimension
- Trendsetter
Best answer by Keiran
Hi Hamza,
I’ve used some sample data I have for an example here, in the Transaction List I create a Property with the Dimension Month
I then select this dimension to add a formula
I then use the TIMEDIM function | Community (gopigment.com) to write the formula
TIMEDIM(Ticket_Data.'Raised Date',Month)
This gives me the correct dimension.
Hopefully this helps! :)
+6- Wallflower
Hi
If I’ve understood your post correctly, you will need to use the following function in your formula definition on the property that will hold the month. Try the following format:
TIMEDIM(BlockName.Property, Month)If your Month dimension exists in another application, I’d advise using the autocomplete dropdown to make sure you’re properly referencing that dimension.
Hope this helps!
Mat | Pigment Specialist
+11- Employee
- Answer
Hi Hamza,
I’ve used some sample data I have for an example here, in the Transaction List I create a Property with the Dimension Month
I then select this dimension to add a formula
I then use the TIMEDIM function | Community (gopigment.com) to write the formula
TIMEDIM(Ticket_Data.'Raised Date',Month)
This gives me the correct dimension.
Hopefully this helps! :)
Keiran | Pigment Specialist (Head of Support, EMEA)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.