Limit Data on Chart

Question & Answer
1

Hi, i have column month with string data type (Dec 2021, Jan 2022 - Dec 2022 and etc)
how to showing data only 13 month with the latest month data?

Thanks

2

You’ll want to apply a filter using the relative month functionality. Here’s some specific guidance on how to achieve that goal:

3

I would cast this string to a date and then do a relative filter for the latest month.

To cast your filed to a date here is the syntax I would use.

parseDate(concat(‘01-’,replace({date_field},’ ‘,’-')),‘dd-MMM-yyyy’)

What this does is that it formats the date_field to be 01-Dec-2022 and then you can parse that date with ‘dd-MMM-yyyy’.

Once you have that field you can use todds answer above to filter ^