Hello
I'm making a line chart, and I want to make a line chart with additional and total amounts by date. In the current method, I tried to make two aggregates to obtain the total amount and the count of Regdate, and then proceed with two data points, but a line chart was formed different from what I intended. Please tell me how to make a line chart with the total number linked to the update and showing the total amount.There are 2 line charts in the screenshot, but I want all the information of 2 charts to be included in one.
I'm sorry I couldn't upload the OML file due to personal reasons.
I think this is what you are looking for
Here the blue line is the actual values and yellow one is its total.
You can achieve this by using the Series Name property of Data Points. In your case, the aggregate shown in 1.PNG, which returns 27, is not required. Instead, prepare a new set of Data Points from the aggregate shown in 2.PNG during the OnAfterFetch event. Use the following mapping:
Finally, append these new Data Points to the main Data Points (mapped from the aggregate).
Attached a sample oml for your reference. Here I am loading the data in OnInitialise.
Could you please share a sample chart ( mockup ) of what you are trying to accomplish ?
Thank you for your reply.
I think this is a similar chart to what you are looking for. This example chart uses both line and bar charts, but I would like to create a chart using only line charts or area charts.
It works, thank you