How to show only last month data on a line chart

[GaryChin]

Hi All,

I would like to only show the last month data on a line chart.

The field name and content are "measure_time" and "MM/DD/YYYY hh:mm:ss AM"

Any idea of the expression?

Best & Regards

Gary

[Arthur_Fong]

Do you have month field in your data? If yes,

Try this:

=SUM({<measure_month={"$(=month(addmonths(max(measure_time),-1)))"}>} measure)

[Kashyap_R]

Hi 

if you have the date try this

=SUM({<Date={">=$(=monthstart(addmonths(max(Date),-1)))<=$(=monthend(addmonths(max(Date),-1)))"}>} measure)

hope this helps

Thanks

[GaryChin]

Sorry. I don't have month field in my data

[Kashyap_R]

Hi

You can use the date in the expression

just replace the Date with your Date column

and measure with your Measure column

Thanks

[GaryChin]

I have 3 field: measure_time, measure_point, measure_value

I binding the measure_time to the Dimensions Field of Line Chart

In the Measure Field the syntax shown below:

=sum({<measure_time={">=$(=monthstart(addmonths(max(date),-1)))<=$(=monthend(addmonths(max(date),-1)))"}>} measure_value)

or 

=sum({<measure_time={">=$(=monthstart(addmonths(max(measure_time),-1)))<=$(=monthend(addmonths(max(measure_time),-1)))"}>} measure_value)

or 

=sum({<Date={">=$(=monthstart(addmonths(max(measure_time),-1)))<=$(=monthend(addmonths(max(measure_time),-1)))"}>} measure_value)

The line chart also no change

I just want to show Dec data.

Thanks

[Kashyap_R]

Hi

Can u share the QVF I will see what is actually not working

Thanks

[GaryChin]

Sure. Here is the QVF and data

[Kashyap_R · Accepted solution]

Hi 

I have created some 4 different charts you can use

PFA 

Thanks

[GaryChin]

Thank You!