If sqlite and csv files don't exist (connections added before but then files are deleted), dbplot crashes.
Also, could you add the feature for multiple plots per chart area? Putting many points on a single plot makes it hard to see.
Thanks,
MDM
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The scatter plot should be there already. You can pick X axis is your first variable, Y axis is your second variable, and Chart Type is Point or Fast Point.
Hope it helps,
HNgo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Great App!
I'm not sure what the "Refresh" button does. What would be great is to have it re-read the data and then regenerate the plots.
This would be a great time saver for me as I am testing programs that generate CSV files and I am using your app to view the data generated. Currently each time I perform a run I must press the "Execute" button on the Query, and then re-select the items to plot ... usually the same ones I had previously. It would be much simpler to just press the "Refresh" button.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for using the tool! The "Refresh" button is to redraw the plot. However, when you click execute, the new data set is queried from the source, thus, all the previous selections are reset to the initial state (ie. blank). So to do what you suggest, I'll add an option to preserve the previous plotting options. Please check the next version in few days.
I also had a roadmap to support what you suggested in a more systematic way in version 3 of DBPlot. The feature named "report" feature. It allows you to make reports using data from multiple connections.
Thanks,
HNgo
Last edit: DBPlot 2013-12-19
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
One thing that looks like a bug.
I use a CSV file with a large number of columns. When I use the pull down list for selecting a column to a plot axis, the scroll arrows show at the top and bottom of the list, but when my cursor reaches the scroll arrows, the list collapses and I cannot scroll it.
As a work-around, I adjust the CSV file to keep the number of columns small enough so that the list displayed fits on my monitor (vertically).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Les,
You are right! I've submitted this ticket. In the mean time, please use the up and down arrows on your keyboard if your drop down list is too long.
Thanks,
HNgo
Last edit: DBPlot 2013-12-18
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have been using the app a lot and I have noticed a couple of things that should be easy to add.
(1) the readout of the x and y axis values at the cursor are handy, but it needs to add a display of the second y axis value when there is a display scale shown for the second axis.
(2) I don't see any way to control the scaling of either y axis other than the zoom controls. These aren't very precise. It would be nice to have a way to set specific values for the max and min y-axis values.
I still think it is a great app!
thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you very much for using the tool and appreciate your feedbacks. I'm curious about what kind of data you are working with and how you look at it since I'm working on the documentation and want to capture more real use cases.
About your suggestions, (1) is very useful. I didn't think of it before. (2) is already addressed. Some of my colleagues asked for the same thing few months ago. To do (2), please follow these steps:
- In the graph tabpage, click on "Customize" button
- Under "Chart" section, select "ChartAreas"
- In the "Area1", under "Axes" section, select "Axes"
- In the "Axes Collector Editor", pick the axis you want to customize (the left panel). In the right panel, under "Scale" section, there is "Maximum" and "Minimum" fields. You can enter the scale you want there.
- After you have done that, going back to the "ChartCustomizationForm", there are 2 options: "Save Permanently" and "Close". If you pick "Save Permanently" then the configuration you just did will be there next time you use the tool. If you click "Close" then it affects only the current transaction.
Thanks again!
HNgo
Last edit: DBPlot 2014-01-10
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As far as some example information, I can share some information with you ... give me a couple of days to collect and document a simple set of data and my usage process that I can give to you.
Your comments on item 2 are most helpful. It appears that this is a method to accomplish the refreshing a graph after re-executing the query (one of my previous requests). But there is an issue, the selected items do not replace the button titles for "[X Axis]", etc. Otherwise this works perfectly! (It might be nice to modify the legend to list the items plotted on the primary y axis separate from the ones on the secondary y axis.)
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
About the Refresh you asked for, I'm working on the report feature where you can create a report and run across all connections, sessions, and transactions. The customize feature are not meant for what you asked for. I'll get the report feature done today or tomorrow, at least for the Csv file.
I find your feedbacks very helpful. Please continue doing so.
Thanks,
HNgo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Yes, The report feature looks like it will do what I need.
My guess is that this was a bit more difficult to complete than first anticipated, so want to say I really appreciate the effort.
One "little" issue though. I have been modifying the "LIMIT 1000" to be 1000000. My CSV files are typically 100,000 lines long. (And I sometimes generate groups of 6 files, each of which is 100,000 lines.)
In the query interface I can set the number of lines. (Would love to be able to permanently modify the default of 1000 to be 100,000.) But the report interface seems to be using the 1000 item default query limit.
I am working on the example to send. Any suggestions as to what the information I should send to you? I have started a brief Word doc, and was thinking of adding some screenshots of the steps I take to display and evaluate my data.
thanks again,
Les
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The ultimate goal with the report is that users will define a custom function (SQL query or Python function) and then map the report to a function. A function can do real queries on CSV files as well as DB systems (Right now, DBPLot has not had the capability to query CSV files. It will be there in V.3)
The report feature should not have any interference from external resources (e.g. the limit 1000 text field). Thanks for raising the issue. I will remove the "Limit" tonight with the new release.
For the documentation, I'd appreciate if you can add screenshots and show how you analyze your data. I'm working on the .html documents to put them all together. Also, I'm looking at some other frameworks for data analytics to integrate one into DBPlot so it would be great if you can list statistical methods (e.g. linear regression, correlations, etc.) you usually use.
Please send your documents to "hngo.opensource@gmail.com".
Thank you very much for your contribution.
HNgo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks for the feedback. It's there in the Customize. LES asked the same questions. I have answered above and just copied here:
In the graph tabpage, click on "Customize" button
Under "Chart" section, select "ChartAreas"
In the "Area1", under "Axes" section, select "Axes"
In the "Axes Collector Editor", pick the axis you want to customize (the left panel). In the right panel, under "Scale" section, there is "Maximum" and "Minimum" fields. You can enter the scale you want there.
After you have done that, going back to the "ChartCustomizationForm", there are 2 options: "Save Permanently" and "Close". If you pick "Save Permanently" then the configuration you just did will be there next time you use the tool. If you click "Close" then it affects only the current transaction.
I will document this and also facilitate this feature since more and more people ask about this.
Thanks,
HNgo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I noticed that the way the secondary axis behaves when zooming has changed. Earlier versions of the software did not change the Y-axis scaling of the secondary axis when a zoom was selected. The latest (2.4.5) will zoom the secondary axis, but not in the area that was selected by the mouse.
I'm not sure what the best option is, but the original behavior was something that could be used as an advantage. Another option would be to zoom only one axis at a time, using the shift or control key (for example) to select that the secondary axis scale is being zoomed.
Also, if the secondary axis is zoomed, a scrollbar for the secondary axis would be useful.
thanks,
Les
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You are right about the change of the behavior. That is intentional for me to work with my data. It may be different for your case and I'm willing to add an option to fix the second Y axis if it helps with your data. But I do want to understand more about what you wrote above.
I'm not quite understand this statement: " The latest (2.4.5) will zoom the secondary axis, but not in the area that was selected by the mouse." The zooming feature will focus on the area selected by the mouse and move the selected area to the middle of the plot automatically. I checked that with my data and it behaved as expected. Could you attach the case that the second axis doesn't zoom in the area selected by the mouse?
The vertical scrollbar is shared b/w the 1st and 2nd axes with the same ratio (ie. if you have Y from 1-100 and Y2 from 1-1000, scrolling Y by 1 will scroll Y2 by 10). I really want to know the case that fixing 1 axis is an advantage. Please share your data if possible.
Thanks,
HNgo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If sqlite and csv files don't exist (connections added before but then files are deleted), dbplot crashes.
Also, could you add the feature for multiple plots per chart area? Putting many points on a single plot makes it hard to see.
Thanks,
MDM
Thanks for your feedback. They are fixed in the new version. Please check the details in the Wiki section.
Hello, I was wandering if you can make a scatterplot? That would be great.
Hello KmM,
The scatter plot should be there already. You can pick X axis is your first variable, Y axis is your second variable, and Chart Type is Point or Fast Point.
Hope it helps,
HNgo
Great App!
I'm not sure what the "Refresh" button does. What would be great is to have it re-read the data and then regenerate the plots.
This would be a great time saver for me as I am testing programs that generate CSV files and I am using your app to view the data generated. Currently each time I perform a run I must press the "Execute" button on the Query, and then re-select the items to plot ... usually the same ones I had previously. It would be much simpler to just press the "Refresh" button.
Hi Les,
Thanks for using the tool! The "Refresh" button is to redraw the plot. However, when you click execute, the new data set is queried from the source, thus, all the previous selections are reset to the initial state (ie. blank). So to do what you suggest, I'll add an option to preserve the previous plotting options. Please check the next version in few days.
I also had a roadmap to support what you suggested in a more systematic way in version 3 of DBPlot. The feature named "report" feature. It allows you to make reports using data from multiple connections.
Thanks,
HNgo
Last edit: DBPlot 2013-12-19
One thing that looks like a bug.
I use a CSV file with a large number of columns. When I use the pull down list for selecting a column to a plot axis, the scroll arrows show at the top and bottom of the list, but when my cursor reaches the scroll arrows, the list collapses and I cannot scroll it.
As a work-around, I adjust the CSV file to keep the number of columns small enough so that the list displayed fits on my monitor (vertically).
Hi Les,
You are right! I've submitted this ticket. In the mean time, please use the up and down arrows on your keyboard if your drop down list is too long.
Thanks,
HNgo
Last edit: DBPlot 2013-12-18
I have been using the app a lot and I have noticed a couple of things that should be easy to add.
(1) the readout of the x and y axis values at the cursor are handy, but it needs to add a display of the second y axis value when there is a display scale shown for the second axis.
(2) I don't see any way to control the scaling of either y axis other than the zoom controls. These aren't very precise. It would be nice to have a way to set specific values for the max and min y-axis values.
I still think it is a great app!
thanks
LES,
Thank you very much for using the tool and appreciate your feedbacks. I'm curious about what kind of data you are working with and how you look at it since I'm working on the documentation and want to capture more real use cases.
About your suggestions, (1) is very useful. I didn't think of it before. (2) is already addressed. Some of my colleagues asked for the same thing few months ago. To do (2), please follow these steps:
- In the graph tabpage, click on "Customize" button
- Under "Chart" section, select "ChartAreas"
- In the "Area1", under "Axes" section, select "Axes"
- In the "Axes Collector Editor", pick the axis you want to customize (the left panel). In the right panel, under "Scale" section, there is "Maximum" and "Minimum" fields. You can enter the scale you want there.
- After you have done that, going back to the "ChartCustomizationForm", there are 2 options: "Save Permanently" and "Close". If you pick "Save Permanently" then the configuration you just did will be there next time you use the tool. If you click "Close" then it affects only the current transaction.
Thanks again!
HNgo
Last edit: DBPlot 2014-01-10
As far as some example information, I can share some information with you ... give me a couple of days to collect and document a simple set of data and my usage process that I can give to you.
Your comments on item 2 are most helpful. It appears that this is a method to accomplish the refreshing a graph after re-executing the query (one of my previous requests). But there is an issue, the selected items do not replace the button titles for "[X Axis]", etc. Otherwise this works perfectly! (It might be nice to modify the legend to list the items plotted on the primary y axis separate from the ones on the secondary y axis.)
Thanks
LES,
I look forward for the data.
About the Refresh you asked for, I'm working on the report feature where you can create a report and run across all connections, sessions, and transactions. The customize feature are not meant for what you asked for. I'll get the report feature done today or tomorrow, at least for the Csv file.
I find your feedbacks very helpful. Please continue doing so.
Thanks,
HNgo
LES,
The new report feature (currently support only CSV) should solve your problem with the refresh button.
Please let me know if anything else I can help.
Thanks,
HNgo
Yes, The report feature looks like it will do what I need.
My guess is that this was a bit more difficult to complete than first anticipated, so want to say I really appreciate the effort.
One "little" issue though. I have been modifying the "LIMIT 1000" to be 1000000. My CSV files are typically 100,000 lines long. (And I sometimes generate groups of 6 files, each of which is 100,000 lines.)
In the query interface I can set the number of lines. (Would love to be able to permanently modify the default of 1000 to be 100,000.) But the report interface seems to be using the 1000 item default query limit.
I am working on the example to send. Any suggestions as to what the information I should send to you? I have started a brief Word doc, and was thinking of adding some screenshots of the steps I take to display and evaluate my data.
thanks again,
Les
LES,
The ultimate goal with the report is that users will define a custom function (SQL query or Python function) and then map the report to a function. A function can do real queries on CSV files as well as DB systems (Right now, DBPLot has not had the capability to query CSV files. It will be there in V.3)
The report feature should not have any interference from external resources (e.g. the limit 1000 text field). Thanks for raising the issue. I will remove the "Limit" tonight with the new release.
For the documentation, I'd appreciate if you can add screenshots and show how you analyze your data. I'm working on the .html documents to put them all together. Also, I'm looking at some other frameworks for data analytics to integrate one into DBPlot so it would be great if you can list statistical methods (e.g. linear regression, correlations, etc.) you usually use.
Please send your documents to "hngo.opensource@gmail.com".
Thank you very much for your contribution.
HNgo
OOOH!
I just figured out that with the report I can still edit the "LIMIT 1000" and re-execute the query.
Les
Les,
The new version (2.4.4) removed the Limit from the report and also have the second Y axis showed in the plot tabpage.
Thanks,
HNgo
Thanks, it works good!
Hi,
Here is a suggestion about a new function.
I find it usefull to customize the Y axis origin in graphic.
For instance in my graph, all my dots are between 600 and 650 on the Y axis. As the axis starts from 0, curve variations are not very visible.
-> I would like to visualize the [600 - 700] range only on the Y axis.
I thought I would find that function in the "Customize" menu, but I don't.
Thiery,
Thanks for the feedback. It's there in the Customize. LES asked the same questions. I have answered above and just copied here:
I will document this and also facilitate this feature since more and more people ask about this.
Thanks,
HNgo
Gr8.
Sorry for that. I read the topic befroe posting, but didn't see it. Getting old, seeing badly ...
I noticed that the way the secondary axis behaves when zooming has changed. Earlier versions of the software did not change the Y-axis scaling of the secondary axis when a zoom was selected. The latest (2.4.5) will zoom the secondary axis, but not in the area that was selected by the mouse.
I'm not sure what the best option is, but the original behavior was something that could be used as an advantage. Another option would be to zoom only one axis at a time, using the shift or control key (for example) to select that the secondary axis scale is being zoomed.
Also, if the secondary axis is zoomed, a scrollbar for the secondary axis would be useful.
thanks,
Les
Les,
You are right about the change of the behavior. That is intentional for me to work with my data. It may be different for your case and I'm willing to add an option to fix the second Y axis if it helps with your data. But I do want to understand more about what you wrote above.
I'm not quite understand this statement: " The latest (2.4.5) will zoom the secondary axis, but not in the area that was selected by the mouse." The zooming feature will focus on the area selected by the mouse and move the selected area to the middle of the plot automatically. I checked that with my data and it behaved as expected. Could you attach the case that the second axis doesn't zoom in the area selected by the mouse?
The vertical scrollbar is shared b/w the 1st and 2nd axes with the same ratio (ie. if you have Y from 1-100 and Y2 from 1-1000, scrolling Y by 1 will scroll Y2 by 10). I really want to know the case that fixing 1 axis is an advantage. Please share your data if possible.
Thanks,
HNgo
Here are some screen captures that demonstrate the problem.
Here is another example from another part of the plot. It may be easier to see the issue.
The data file is kind of large, but I will send it if you wish.