Simple curve report? | Community
Skip to main content
Level 3
February 13, 2018
Solved

Simple curve report?

  • February 13, 2018
  • 1 reply
  • 1464 views

Hi all,

I think I've stuck... Current idea: as my AC6.1 has external data sources and every day some data is changing + users creating and sending campaigns, I want to build a set of reports representing values for a set of indicators (e.g. number of Recipients, number of custom entities, etc) by date.

So, I've spent couple of hours to understand AC reporting (seems like with no luck at all... SSRS, I love you!) and now need your help and advises.

Let's pretend I have the following data:

Date,Num1,Num2

"02/01/2018",1000,300

"02/02/2018",2000,100

"02/03/2018",3000,200

"02/04/2018",4000,300

"02/05/2018",3000,340

"02/06/2018",5000,350

"02/07/2018",8000,370

"02/08/2018",10000,500

"02/09/2018",2000,400

"02/10/2018",4000,600

"02/11/2018",12000,800

"02/12/2018",10000,900

"02/13/2018",11000,400

Here I have 3 columns: first with date, and two with integers.

I want the Date to be my X axis, numbers (from 0 to 20 000 or something) to be on Y axis; and I want Num1 and Num2 to be curves representing Num's values for each date.

I see X axis here, ok. But how to manage curves? Series want 'Operator', but my data is ready to go, I don't need any aggregations.

Please help me understand this feature...

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by florentlb

Hi,

Have you seen this page about creating charts? Creating a chart

Hope this helps,

Florent

1 reply

florentlb
florentlbAccepted solution
Level 10
March 12, 2018

Hi,

Have you seen this page about creating charts? Creating a chart

Hope this helps,

Florent