Data>Import Special is unintuitive; no “natural” way to handle percentages.

DataGraph Forums › Technical Support › Feedback and Suggestions › Data>Import Special is unintuitive; no “natural” way to handle percentages.

  • This topic has 0 replies, 1 voice, and was last updated 1 month ago by adam nealis.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • #15929
    adam nealis
    Participant

      TL;DR (but you should):

      1. Implement a way to handle data fields that contain a % character, either by a column type or a conversion function.
      2. 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.

    Viewing 1 post (of 1 total)
    • You must be logged in to reply to this topic.

    DataGraph Forums › Technical Support › Feedback and Suggestions › Data>Import Special is unintuitive; no “natural” way to handle percentages.