{"action":"created","issue":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/820","repository_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser","labels_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/820/labels{/name}","comments_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/820/comments","events_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/820/events","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/820","id":182661890,"number":820,"title":"Plot: Add as an available vector, the row # of the query","user":{"login":"struck89","id":18152095,"avatar_url":"https://avatars.githubusercontent.com/u/18152095?v=3","gravatar_id":"","url":"https://api.github.com/users/struck89","html_url":"https://github.com/struck89","followers_url":"https://api.github.com/users/struck89/followers","following_url":"https://api.github.com/users/struck89/following{/other_user}","gists_url":"https://api.github.com/users/struck89/gists{/gist_id}","starred_url":"https://api.github.com/users/struck89/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/struck89/subscriptions","organizations_url":"https://api.github.com/users/struck89/orgs","repos_url":"https://api.github.com/users/struck89/repos","events_url":"https://api.github.com/users/struck89/events{/privacy}","received_events_url":"https://api.github.com/users/struck89/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-10-12T23:48:47Z","updated_at":"2016-12-20T15:44:29Z","closed_at":"2016-12-19T18:59:05Z","body":"### Details for the issue\n\nI usualy plot x vs y, but what happens when you only want to plot y? Let me put my example:\n\nIn this image, I want to see, visually, how the variable \"Total Volume\" is distributed, Using only what is available:\n![series](https://cloud.githubusercontent.com/assets/18152095/19331568/690a583a-90b3-11e6-826d-14bdd1ba67ac.PNG)\nBut it would be very useful to also have this:\n![series2](https://cloud.githubusercontent.com/assets/18152095/19331716/ea788626-90b3-11e6-9347-dc7f80b4f0fe.PNG)\n\nWhich would be solved if this was added:\n![result](https://cloud.githubusercontent.com/assets/18152095/19331799/affaf0be-90b4-11e6-939d-dcf81f2fa581.png)\n\n<!--\n\nThanks for coming here to report an issue. :)\n\nPlease describe it in this section, fill out the correct check boxes\nbelow with an \"x\", then click the \"Submit new issue\" button at the bottom\n\n-->\n### Useful extra information\n\nMost probably there is a SQL command that generates such a column, I idon't know. I still think it would be a neat feature.\n\n<!-- The info below often helps, please fill it out if you're able to. :) -->\n#### I'm opening this issue because:\n- [ ] DB4S is crashing\n- [ ] DB4S has a bug\n- [X] DB4S needs a feature\n- [ ] DB4S has another problem\n#### I'm using DB4S on:\n- [X] Windows: ( _version:_ ___ )\n- [ ] Linux: ( _distro:_ ___ )\n- [ ] Mac OS: ( _version:_ ___ )\n- [ ] Other: ___\n#### I'm using DB4S version:\n- [X] 3.9.1\n- [ ] 3.9.0\n- [ ] Other: ___\n#### I have also:\n- [ ] Tried out the nightly version: https://github.com/sqlitebrowser/sqlitebrowser#windows\n- [X] Searched for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\n"},"comment":{"url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/comments/268276350","html_url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/820#issuecomment-268276350","issue_url":"https://api.github.com/repos/sqlitebrowser/sqlitebrowser/issues/820","id":268276350,"user":{"login":"struck89","id":18152095,"avatar_url":"https://avatars.githubusercontent.com/u/18152095?v=3","gravatar_id":"","url":"https://api.github.com/users/struck89","html_url":"https://github.com/struck89","followers_url":"https://api.github.com/users/struck89/followers","following_url":"https://api.github.com/users/struck89/following{/other_user}","gists_url":"https://api.github.com/users/struck89/gists{/gist_id}","starred_url":"https://api.github.com/users/struck89/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/struck89/subscriptions","organizations_url":"https://api.github.com/users/struck89/orgs","repos_url":"https://api.github.com/users/struck89/repos","events_url":"https://api.github.com/users/struck89/events{/privacy}","received_events_url":"https://api.github.com/users/struck89/received_events","type":"User","site_admin":false},"created_at":"2016-12-20T15:44:29Z","updated_at":"2016-12-20T15:44:29Z","body":"Hey @MKleusberg !\r\nI have to say that I found other issues with that nighlty build. For example that between queries that had as an output the same columns, it did not remember the ones that were being plotted.\r\nBefore I had column1 as X and column2 as Y and after running a new query the graph got updated. With the nightly I had to select the columns to be plotted again.\r\nAlso I remember (it's been a month without playing with it), a significant decrease in performance when selecting the columns to plot. I don't know if that was a consequence of the feature I wished it had, or by some other addition..\r\n\r\nAnd those where PV loops. Pressure-Volume loops of the left ventricle of a simulation of a human heart!\r\n90% of what I was plotting were Pressure vs Time or Pressure vs Volume of all different heart chambers; the most iconic being the left ventricle.\r\n\r\nBest regards and merry xmas!"}}
{"actor":{"display_login":"struck89"}}