Skip to main content
Solved

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?

  • Mar 14, 2023 8:53 PM UTC
  • 2 replies
  • 87 views
Level 8
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?

Best answer by marcin.szcze12

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));

View original

      2 replies

      Level 4
      Forum|alt.badge.img

      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));

      Level 8

      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!!

      Community Code of ConductAccessibility statement