Methods and systems for visual data manipulation
A system for visual modification of data. The system comprising, an interface layer for displaying data and for receiving one or more visual inputs for modifying data; a data layer for storing data; and an analysis engine layer for connecting the interface layer and the data layer, wherein the analysis engine layer is configured to receive the one or more visual inputs from the graphical interface for modifying the graphical representation; modify the underlying data based on the visual inputs; modify a derived data based on the modified underlying data; and transfer the modified derived data to the interface layer for display.
1. A method for visual modification of data, the method comprising:
simultaneously displaying a graphical interface and a grid interface, wherein the graphical interface comprises a graphical representation of an underlying data, wherein the graphical representation of the underlying data includes a first chart comprising one or more editable metrics and a second chart comprising one or more values derived from the one or more editable metrics, and wherein the grid interface comprises a tabular representation of the underlying data, wherein the graphical representation of the underlying data includes an original bar, wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar;
receiving one or more visual inputs to the graphical interface for modifying the graphical representation of the underlying data, wherein the one or more received visual inputs modifies at least one of the one or more editable metrics;
in response to the one or more received visual inputs, modifying the underlying data, wherein modifying the underlying data comprises:
changing a corresponding value associated with the at least one of the one or more editable metrics from an original metric value to a modified metric value; and
updating a value of the one or more values derived from the one or more editable metrics from an original derived value to a modified derived value, wherein the original derived value is based at least in part on the original metric value, and wherein the modified derived value is based at least in part on the modified metric value;
displaying, in the graphical interface, an updated first chart and an updated second chart, wherein the updated second chart comprises the original derived value, the modified derived value, and a difference between the modified derived value and the original derived value; and
displaying in the grid interface an updated tabular representation comprising at least one of the modified metric value and the modified derived value.
2. A system for visual modification of data, comprising:
a graphical interface configured to:
simultaneously display a graphical interface and a grid interface, wherein the graphical interface comprises a graphical representation of an underlying data, wherein the graphical representation of the underlying data includes a first chart comprising one or more editable metrics and a second chart comprising one or more values derived from the one or more editable metrics, and wherein the grid interface comprises a tabular representation of the underlying data, wherein the graphical representation of the underlying data includes an original bar, wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar;
receive one or more visual inputs for modifying the graphical representation of the underlying data, wherein the one or more received visual inputs are configured to modify at least one of the one or more editable metrics;
and
a processor configured to:
in response to the one or more received visual inputs, modify the underlying data, wherein to modify the underlying data, the processor is configured to:
change a corresponding value associated with the at least one of the one or more at least one of the editable metrics from an original metric value to a modified metric value; and
update a value of the one or more values derived from the one or more editable metrics from an original derived value to a modified derived value, wherein the original derived value is based at least in part on the original metric value, and wherein the modified derived value is based at least in part on the modified metric value;
display, in the graphical interface, an updated first chart and an updated second chart, wherein the updated second chart comprises the original derived value, the modified derived value, and a difference between the modified derived value and the original derived value; and
display in the grid interface an updated tabular representation comprising at least one of the modified metric value and the modified derived value.
3. A non-transitory computer readable medium storing computer instructions that, when executed by a computer, performs a method for visual modification of data, the method comprising:
simultaneously displaying a graphical interface and a grid interface, wherein the graphical interface comprises a graphical representation of an underlying data, wherein the graphical representation of the underlying data includes a first chart comprising one or more editable metrics and a second chart comprising one or more values derived from the one or more editable metrics, and wherein the grid interface comprises a tabular representation of the underlying data, wherein the graphical representation of the underlying data includes an original bar, wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar;
receiving one or more visual inputs to the graphical interface for modifying the graphical representation of the underlying data, wherein the one or more received visual inputs modifies at least one of the one or more editable metrics;
in response to the one or more received visual inputs, modifying the underlying data, wherein modifying the underlying data comprises:
changing a corresponding value associated with the at least one of the one or more editable metrics from an original metric value to a modified metric value; and
updating a value of the one or more values derived from the one or more editable metrics from an original derived value to a modified derived value, wherein the original derived value is based at least in part on the original metric value, and wherein the modified derived value is based at least in part on the modified metric value;
displaying, in the graphical interface, an updated first chart and an updated second chart, wherein the updated second chart comprises the original derived value, the modified derived value, and a difference between the modified derived value and the original derived value; and
displaying in the grid interface an updated tabular representation comprising at least one of the modified metric value and the modified derived value.
4. The method of claim 1 , wherein a graph chart interface displays one or more of the first chart and the second chart.
5. The method of claim 1 , wherein a bar chart interface displays the original bar or the modified bar.
6. The system of claim 2 , wherein a graph chart interface displays one or more of the first chart and the second chart.
7. The method of claim 2 , wherein the graphical representation of the underlying data includes an original bar.
8. The method of claim 7 , wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar.
9. The method of claim 8 , wherein a bar chart interface displays the original bar or the modified bar.
10. The non-transitory computer readable medium storing computer instructions of claim 3 , wherein a graph chart interface displays one or more of the first chart and the second chart.
11. The non-transitory computer readable medium storing computer instructions of claim 3 , wherein the graphical representation of the underlying data includes an original bar.
12. The non-transitory computer readable medium storing computer instructions of claim 11 , wherein the graphical representation of the underlying data includes a modified bar, wherein the modified bar comprises a first part corresponding to the original bar and a second part corresponding to a difference between the modified bar and the original bar.
13. The non-transitory computer readable medium storing computer instructions of claim 12 , wherein a bar chart interface displays the original bar or the modified bar.
14. The method of claim 1 , wherein the updated first chart comprises the original metric value and the modified metric value.
15. The method of claim 1 , wherein the graphical interface comprises a visual indication that the first chart is editable.