topic Re: How to shorten the filter content in App Development

How to shorten the filter content

Samanehsorournejad — Wed, 04 Jan 2023 13:57:26 GMT

Hi Everyone,

I have a filter with Content Year_Month, previously it shows all of the available value for this Coulmn

but now my Customer want me to show just last Month and current Month.

Is there any person who could help me how I can show just current Month and previous Month in my Filter?

I had tried this one but it gives me error

if(zeitpunktverarbeitungYearMonth>=Max(zeitpunktverarbeitungYearMonth)-1,
zeitpunktverarbeitungYearMonth, null()
)

Thanks in advanced

Re: How to shorten the filter content

rui24 — Wed, 04 Jan 2023 14:11:35 GMT

Hi anehsorournejad

I think you can create a Dimension that search for these 2 field, the current month and the last month.

And when you add these dimension to your field only appear the 2 field that your customer want.

Re: How to shorten the filter content

deepanshuSh — Wed, 04 Jan 2023 16:50:52 GMT

Create a variable having previous month value, i.e

vprevmonth= month(today())-1 or as depicted if any specific format is being used for the month value then use that, and use it first in a table value to check if the values are actually matching or not.Then use

if (monthfieldname>=vprevmonth, monthfieldname, null())

Most likely the error is due to the mismatch in the search string and the data.

Also, while posting the doubt do provide the error facing and the correct dataset for getting better responses and results.

Re: How to shorten the filter content

tkas — Thu, 05 Jan 2023 06:40:43 GMT

If( montnOfyourColumn=month (today()) or montnOfyourColumn=month (today()-30) , montnOfyourColumn=month)

Re: How to shorten the filter content

Mark_Little — Thu, 05 Jan 2023 08:33:51 GMT

Hi,

I would approach this is script, Create a new dimension in your calendar which just populated with the Dates that are equal to this month or last month, then use this field front end,.

Re: How to shorten the filter content

jbhappysocks — Thu, 05 Jan 2023 08:59:04 GMT

Looks like your field zeitpunktverarbeitungYearMonth is not a date field as you have "letzte 30 Tage" as a value. So if you need to create this in the interface you have to do something like this where you define each possible value, you can't base it on a "x>Date" condition .

=if(match(zeitpunktverarbeitungYearMonth,
year(today())&'-'&num(month(today()),'00'),
year(monthstart(today())-1)&'-'&num(month(monthstart(today())-1),'00'),
'letzte 30 Tage')
,zeitpunktverarbeitungYearMonth,
Null())

It will work, but will not look very good:

If you instead add something like this in your script:

NoConcatenate
PeriodSelect:
Load
year(today())&'-'&num(month(today()),'00') as zeitpunktverarbeitungYearMonth
AutoGenerate 1;

Concatenate (PeriodSelect)
Load
year(monthstart(today())-1)&'-'&num(month(monthstart(today())-1),'00') as zeitpunktverarbeitungYearMonth
AutoGenerate 1;

Concatenate (PeriodSelect)
Load
'letzte 30 Tage' as zeitpunktverarbeitungYearMonth
AutoGenerate 1;

left join (datetable)
Load
zeitpunktverarbeitungYearMonth,
zeitpunktverarbeitungYearMonth as "Period Selection"
Resident PeriodSelect; drop Table PeriodSelect;

You will get a new dimension you can use instead of zeitpunktverarbeitungYearMonth that will look better for the user: