Solved

Converting date column to month dimension

  • 5 April 2023
  • 3 replies
  • 302 views

Userlevel 1
Badge
  • Newly Minted Pigmenteer
  • 2 replies

 

icon

Best answer by Keiran 5 April 2023, 17:05

View original

3 replies

Userlevel 3
Badge +4

Hi @Hamza, thanks for your question!

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!

Userlevel 5
Badge +8

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! :)

Userlevel 1
Badge

Thank you Mat and keiran, thank you guys it was clear and very heplful 

Reply