1 Reply Latest reply on Mar 12, 2018 4:01 AM by florentlb

    Simple curve report?

    andreyt99885240 Level 1

      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...