Lets imagine I have a line graph.
My KPI is order count.
My dimension is the months of the year whose data comes from Table A's column B.
So my dimension is ROUND_MONTH("A"."B")
Which filter I need to add to see only the last month?
Page 1 / 1
Hi,
Not quite sure if this is what you need but if you would like to see only items from last month you can use:
FILTER ROUND_MONTH("A"."B") = ROUND_MONTH(ADD_MONTHS(TODAY(),-1));
Hi,
Not quite sure if this is what you need but if you would like to see only items from last month you can use:
FILTER ROUND_MONTH("A"."B") = ROUND_MONTH(ADD_MONTHS(TODAY(),-1));
Thank you, worked!!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.