Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No graphable Fields #99

Closed
ygutgutia opened this issue Jul 2, 2021 · 3 comments
Closed

No graphable Fields #99

ygutgutia opened this issue Jul 2, 2021 · 3 comments

Comments

@ygutgutia
Copy link

ygutgutia commented Jul 2, 2021

I have a local .csv file of the type
time,value
2021-07-02 11:00:00, 101
2021-07-02 11:03:06, 113
2021-07-02 11:05:53, 120
2021-07-02 11:07:32, 132

When I import it in Grafana, the table view shows the data as follows:

Screenshot (690)

But when I try to view it as time series, it shows No Graphable Fields. the current system time is 11:40, therefore time is not an issue.

Screenshot (688)

@marcusolsson
Copy link
Contributor

Thanks for letting me know! Since the numbers are left-aligned in the table, I'm suspecting that they aren't detected as numbers somehow.

Could you check the Query inspector and let me know how the DataFrame structure looks like?

@ygutgutia
Copy link
Author

Hey Thanks for the reply. The error had something to do with the Datetime format. Im sure that the above format is also acceptable because the same data worked fine when I extracted it from a google-sheet. Anyways, I added a GMT at the end in the datetime column and it worked for the local csv file also.

@javiBajoCero
Copy link

javiBajoCero commented Nov 17, 2021

Exactly the same issue here.
imagen
imagen

I dont understand where @ygutgutia added the GMT

Im using grafana 8.2.4 in a Raspberry zero with the plugin marcusolsson-csv-datasource 0.6.1

@marcusolsson Is there a timeless way of displaying the data?
My data consists in some signals sampled each 0,5 miliseconds so a typical grafana date format is of no use to me

imagen
My CSV file:
https://mega.nz/file/wTwR2SAI#1WwXWsyzu-zxZpWkU6uHYhFEv1vESBkTSH_j-PbeJnk
_
_
_
_
_
_
_
_
_
_
_
_
_
_
_
_
_
Edit:
it turns out the data is displayed if i use Stat visualization instead of timseries
imagen

okay i was the problem. This is how you define timeserie Fields
imagen

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants