Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
I'll think Maxstring maybe helps
Sum({<Month={"$(=Maxstring(Month))"},[Media Type]={'PAID MEDIA'}>}Visits)
Hi
your Month field is text data type, not Date type
Please convert to Date type before using
Regards
An Pham
try maxString()
Regards
Hi,
I'll think Maxstring maybe helps
Sum({<Month={"$(=Maxstring(Month))"},[Media Type]={'PAID MEDIA'}>}Visits)
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