=Max(Month) is not working

[bhavvibudagam]

Hi Experts,

In the below attached app I have loaded Month Field. In the filter pane I am able to see Month. But when i have tried to take

=Max(Month) then I am not able to get Dec on Text object.

In the set analysis also Its not working

Sum({<Month={"$(=Max(Month))"},[Media Type]={'PAID MEDIA'}>}Visits)

Please help me on this

Thanks in advance.

[kenphamvn]

Hi

your Month field is text data type, not Date type

Please convert to Date type before using

Regards

An Pham

[big_dreams]

try maxString()

Regards

[stabben23 · Accepted solution]

Hi,

I'll think Maxstring maybe helps

Sum({<Month={"$(=Maxstring(Month))"},[Media Type]={'PAID MEDIA'}>}Visits)

[bhavvibudagam]

Hi ,

Max string is working.

I have used below one in the back end it is also working

Date( Date# ( "Month",'MMM'),'MMM') as Month,

Thanks