Forum Discussion

mikeydk's avatar
mikeydk
New Member
9 years ago
Solved

Basic questions from a beginner

Hey

 

How do I create a line chart from CSV? 

 

(I do only get SUM/COUNT on sale numbers)

 

CSV:

 

Date, Sale

01-01-2017,12

01-02-2017,13

01-03-2017,14

01-04-2017,12

01-05-2017,11

 

Thanks in advance

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi mikeydk,

     

    In your sample dataset, you only have 1 row per day.  In a real dataset, you may have thousands or millions of rows for the 1st Jan, so you can see why the SUM/COUNT might be useful.

     

    Are you getting a basic line chart now with those numbers?

     

     

     

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi mikeydk,

     

    In your sample dataset, you only have 1 row per day.  In a real dataset, you may have thousands or millions of rows for the 1st Jan, so you can see why the SUM/COUNT might be useful.

     

    Are you getting a basic line chart now with those numbers?