CSV data source - use a number column for a time-series graph?

  • What Grafana version and what operating system are you using?
    Grafana v10.0.1 (5a30620b85), running as a Docker container on Unraid (which runs a Linux O/S underneath)

  • What are you trying to achieve?
    I have installed the CSV plugin.
    The data I get is CSV format, for a Fantasy Football. Each week, the latest stats and performance of the players is updated. I download this CSV each week, and concatenate the latest data into a single CSV of all data.
    I add an extra “Gameweek” field in the data source that is just a number for the week.

I am trying to show various stats, either for every player’s performance - i.e. number of goals scored, week by week, or cumulatively over many weeks. Alternatively, I might want to do various Group By calculations, against the many other fields.

  • How are you trying to achieve it?
    I have added the CSV as a data source. In the Data’s “Query” tab, I have forced specific fields to be of specific data types, setting “Player ID” and “Gameweek” as Number, and “Full Name” to String.
    Click the “Add Visualisation” link, but “Time-Series” never works…

  • What happened?
    No graph data is produced!

  • What did you expect to happen?
    A time-series graph

  • Sample Data
    Upon request, here is an filtered view of the data, with only 3 players listed (with data for the first 3 weeks):

    ID	    Web Name	    Player ID	    Full Name	    Team	    News	    Position	    Current Price	    Value Season	    Cost Change from Start	    Percentage selected by	    Transfers In	    Transfers Out	    Total Points	    Points Per Game	    Minutes	    Goals Scored	    Assists	    Clean Sheets	    Goals Conceded	    Own Goals	    Penalties Saved	    Penalties Missed	    Yellow Cards	    Red Cards	    Saves	    Bonus Points	    Bonus Point System Score	    Influence	    Creativity	    Threat	        ICT Index	    EA Index	GW	
355	        Haaland	223094	        Erling Haaland	43	        	4	140	19.4	0	86.5	0	0	272	7.8	2767	36	9	13	26	0	0	0	5	0	0	40	1040	1390.0	371.0	1825.0	358.1	        	1	
504	        Maddison	172780	        James Maddison	6	        	3	75	18.0	0	13.1	0	0	135	4.5	2479	10	9	4	54	0	0	1	10	0	0	9	520	802.4	984.9	805.0	259.7	        	1	

50	        McGinn	122806	        John McGinn	7	        	3	55	16.4	0	0.5	0	0	90	2.6	2692	1	5	10	31	0	0	0	7	0	0	3	354	382.0	353.6	347.0	108.3	        	1	






355	        Haaland	223094	        Erling Haaland	43	        	4	140	0.9	0	90.7	126721	12112	13	13.0	79	2	0	1	0	0	0	0	0	0	0	3	56	67.6	23.7	48.0	13.9	        	2	
504	        Maddison	172780	        James Maddison	6	        	3	75	1.2	0	13.5	169521	29155	9	9.0	90	0	2	0	2	0	0	0	1	0	0	2	31	49.2	82.9	21.0	15.3	        	2	

50	        McGinn	122806	        John McGinn	7	        	3	55	0.4	0	0.5	1407	3257	2	2.0	63	0	0	0	3	0	0	0	0	0	0	0	6	0.8	18.1	0.0	1.9	        	2	






355	        Haaland	223094	        Erling Haaland	43	        	4	140	1.1	0	91.1	207120	42352	15	7.5	169	2	0	2	0	0	0	0	0	0	0	3	57	70.8	35.5	96.0	20.2	        	3	

504	        Maddison	172780	        James Maddison	6	Knock - 75% chance of playing	3	76	1.6	1	14.3	368457	175483	12	6.0	180	0	2	1	2	0	0	0	1	0	0	2	43	65.6	124.8	53.0	24.3	        	3	
50	        McGinn	122806	        John McGinn	7	        	3	55	2.2	0	0.5	8339	6377	12	6.0	153	1	0	1	3	0	0	0	0	0	0	2	37	44.6	22.4	33.0	10.0	        	3

Please post sample csv colums and values