Edit data of data series at any time - even to modify the data series after you created or uploaded it.

To Edit Data, switch to Editing Mode 

    

To Save your changes in Edit Mode, always click the Apply Changes Icon   

    

 

Let's make an example to show how you can apply the functionalities of the Data Capture Widget to edit data:

  1. Create a Data Series with growing values
  2. Spread values evenly over all months of a quarter
  3. Spread values evenly over all quarters of a year
  4. Spread values evenly over all months of a year

1. Create a Data Series with growing values

Use the Create Data Series  functionality to create a data series with an initial value of $1000 growing by $100 per month.

This is how the data series looks like in the Values View.

 

2. Spread values evenly over all months of a quarter

To spread values evenly over all months of a quarter

  • Select the Monthly Form 
  • Select the Values View to check your monthly data series (e.g. it shows 1100+1200+1300 in the first quarter) 
  • Switch to the Quarterly Form to see how your data aggregates by quarter (e.g. 3600=1100+1200+1300 in the first quarter)



  • Click the icon "Apply Changes"
  • Check that your Quarterly data was now evenly spread over all month of the quarter (e.g. it shows 1200 for all 3 months in the first quarter) 



  •  Check the chart showing a step-wise function.

     

 

3. Spread values evenly over all quarters of a year

To spread values evenly over all quarters of a year

  • Select the Quarterly Form 
  • Select the Values View to check your quarterly data series (e.g. it shows 3600, 4500. 5400, 6300 for the first four quartes) 
  • Switch to the Yearly Form to see how your data aggregates by quarter (e.g. 19800=3600+4500+5400+6300 for in the first year)

     

  • Click the icon Apply Changes
  • Switch to the Quarterly Form to check that your Quarterly data was now evenly spread over all month of the quarter (e.g. it shows 4950 = 19800/4 for all quarters in the first year) 



  •  Check the chart showing a step-wise function.

  

4. Spread values evenly over all months of a year

To spread values evenly over all months of a year, continue on the quarterly view before

  • Click the icon Apply Changes
  • Select the Monthly Form to Check that your Quarterly data was now evenly spread over all month of the quarter (e.g. it shows 1650 = 4950/3 for all months in the first quarter) 

      

  • Check the chart showing a step-wise function.