TL;DR (but you should):
- Implement a way to handle data fields that contain a % character, either by a column type or a conversion function.
- Improve the ergonomics of Data > Import Special
Long version
I tend not to try to set up graphs in DG very often. When I do I tend to be hit by a double-whammy of not having the muscle memory to handle what I regard as the necessary workarounds (you might claim this is the ‘correct’ way to do it) plus the actual it’s-like-learning-to-fly-a-helicopter ergonomics of said ‘correct’ way to do it.
So far, after several years of trying – not intensively I might add – I haven’t come up with a single robust way to get data out of something and into a file that DG can handle the next time I open a .dgraph file. I still dutifully open DG and copy/ paste numbers into the data fields. Data I can tell computers to retrieve on my behalf.
I allowed myself to be misguided into using Data > Import Special in an attempt to handle a data column containing data like this:
45%
It seems, in the 21st Century, I (not DG) must remove all “%” characters in any column that wants to be treated as a number. So I have to pre-process the source data because it contains “%” characters or do search/ replace post import. As I want to create and update a CSV file via timed reload it looks like I must pre-process the data. Well OK, but DG’s not being able to handle percentages as a data type, else a friendly nudge of having a function to strip out “non-number” characters is approaching unreasonable (in my estimation).
As for my “Data > Import Special is unintuitive” claim, I proceeded to try to import my CSV. I have to tell you that this was extremely painful. Just getting the header line recognised was bizarre. Why can’t I from the outset just say “turn line 1 into headers”?
Anyway, as I learned Data > Import Special would not strip my % characters, I gave up trying to set up my column headers and will work on removing “%” characters from the data before they are written to the CSV.
This is exactly the kind of thing that makes it difficult to use DG on an occasional basis.