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?

  • March 14, 2023
  • 2 replies
  • 3 views
Z
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));

    2 replies

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

    Z
    Level 8
    • zeliha.otgöz
    • Author
    • Level 8
    • March 15, 2023

    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