Creating Trend Analysis

Hi everyone, I’m trying to create a trend analysis using the MYLineChart plugin, but I’m running into an issue with how the data is displayed.

My current setup is:

  • Categories: Monthly (Dates)

  • Data: Amount

  • Labels: CustomerNo

The Issue: Instead of showing a continuous trend across the months, the chart only renders one data point for January and then stops.

Am I missing a step in how I should group my data or how I should format the “Search for…” expression? Any guidance on how to properly set up a multi-month trend with this plugin would be greatly appreciated!

You can do it by using :group by … and the. Choose by month

I have already done that, but it’s not working