Adding appendcols to table to produce two curves

supremefeast — Wed, 03 Mar 2021 22:49:40 GMT

I'm creating demand and supply curves which use streamstats to accumulate demand and supply in order to intercept the curves (and thereby visually display the market price). Streamstats is used on the "Volume" field since supply is presented in bands (e.g. progressively adding 1,000 units sold @ $2 and 2,200 units sold @ $3, etc) so I need to progressively add these Volume bands/steps in order to make a positive gradient curve.

| search participant_name ="*" code = "*" offer_type = "Supply" | where Price >= 0 AND Price < 7 | streamstats sum(Volume) as Cumm1_GJ | eval Supply_GJ = round(Cumm1_GJ,0)

On the other hand, demand again is presented in bands but the curve has a negative gradient. Therefore, I used the reverse command to reverse the actions of streamstats - i.e. starting at 40,000 Volume units demanded @ $0, then 38,000 Volume units demanded @ $1, etc.

This is where I'm stuck. I do not get the two curves I expected to see in Visualization.

Re: Adding appendcols to table to produce two curves

tscroggins — Sun, 07 Mar 2021 21:39:22 GMT

@supremefeast

Using nonsensical--I'm not an economist--synthetic data generates two intersecting curves:

Can you provide a small set of sample data?

topic Adding appendcols to table to produce two curves in Splunk Search

Adding appendcols to table to produce two curves

Re: Adding appendcols to table to produce two curves