static KPI

[Timste]

Hello, I need a static KPI for the last 30 days with no reference to the filters. What I'm doing wrong?

That's my function:

Sum({1< date = {"=date >= Today() - 30"} >} [sales])

This function for last month works fine, but i need last 30 days. Where is the difference?

Sum( { 1< [date.autoCalendar.MonthsAgo]={1} > } [sales] ) 

Thank you!

[MayilVahanan]

Hi @Timste 

Try like below

Sum({1< date = {">= $(=Date(Today() - 30,'YourDateFormat')"} >} [sales])

[Timste]

Hey Mayil, thank you for the reply but this doesn't work for me. Maybe my function was a little bit confusing because of the fieldname "date". So this is my function. This works fine without using filters.

Sum({1< invoicedate = {"=invoicedate >= Today() - 30"} >} [sales])

I also tried it with the dateformat, but without success. Any idea?