Dear Community,
I have a transaction List and have a Property which Type is Dimension (Month) Text.
I’m looking to create a metric that tells me the latest month on that property.
How can I achieve that?
Thanks in advance :D
Dear Community,
I have a transaction List and have a Property which Type is Dimension (Month) Text.
I’m looking to create a metric that tells me the latest month on that property.
How can I achieve that?
Thanks in advance :D
Hi Guillermo,
I wrote an article a while back on this topic!
You’ll have to turn your text value in a Month or a date though before proceeding - you can do that with those functions - share with us your format if you need more help!
Hi,
I wanted to add a remark on this because I often see errors around the modifier behaviors.
Here, by “Latest” I know you want to return the most recent Month, and intuitively, you might want to use the “Last” or “Lastnonblank” modifier.
"Last" versus "Max" modifiers
Last is the last item of the list, from top to bottom, so if your list isn't chronologically ordered like ListC in the example below, you might end up with having unexpected results.
Max returns the highest value, no matter the order of the items.
Let’s take this list as an example:
You can notice that Rome has 2 values but their order is not logical.
if you want to return the last Month on all the rows:
if you want to return the highest Month value on all the rows:
if you want to return the last Month by a List dimension (Location in this example):
if you want to return the highest Month value by a List dimension (Location in this example):
Hope it helps.
Best,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.