Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I want to select a specific value in a pivot; I use this expression and it works
{<GROUP={'Group1'},Category={'Complaint'}, Year={'2023'},Month={'2'}>}Count(TICKET_ID)
But; I dont want to change script every month; so I want to use a variable in this script but it doesnt work. Instead of Month={'2'}; I tried:
How can I solve this problem?
Thanks
Hi
Try like below
{<GROUP={'Group1'},Category={'Complaint'}, Year={'2023'},Month={'$(=Month(Today()))'}>}Count(TICKET_ID)
Hi
Try like below
{<GROUP={'Group1'},Category={'Complaint'}, Year={'2023'},Month={'$(=Month(Today()))'}>}Count(TICKET_ID)
Yeyyy, It works! Thanks a lot 🙂