topic One chart with filter date range and another one with the last month of filter date range in App Development

One chart with filter date range and another one with the last month of filter date range

marcodelgrosso — Tue, 28 Jun 2022 16:00:54 GMT

Hey,

I've two charts, the first one displays the values about filter date range (I did it), but the second one is a barchart that has to refer only to the last month of filter date range. How can I do that?

As in the following example: the filter range date is Feb 22 to May 22 but the barchart has to display the sum of data about only May 22.

Re: One chart with filter date range and another one with the last month of filter date range

MartW — Tue, 28 Jun 2022 19:53:16 GMT

This is quite easy, you need some set analysis within the barchart (meassures)

I don't know the field you use in you meassure and how the month name is but the set analysis would be something like this

Sum ( { < Monthfield= {"$(=max(Monthfield))"} > } Measure field)

Re: One chart with filter date range and another one with the last month of filter date range

marcodelgrosso — Tue, 05 Jul 2022 13:36:26 GMT

Perfect solution! It works such as I wanted to.

Thank you so much