Results 1 to 8 of 8

Thread: Crosstab over a 3 coumns array

Threaded View

  1. #7
    PowerPoster dilettante's Avatar
    Join Date
    Feb 2006
    Posts
    24,487

    Re: Crosstab over a 3 coumns array

    Ok, instead of a specific Value Class I decided to do this more generically using a Variant containing an array instead.

    That makes it easier to use this version of Tabulator with different numbers of different values. However I only implemented Sum & Avg, so if you want things like Min, Max, etc. you could add those too based on earlier versions of TabulatorCell.

    Nothing special to accomplish this or do other kinds of things with Tabulator, it's all "plain sailing" as programming goes.

    A wrinkle here is the use of two menu items for "Random" and "Verify" runs. I added the verification run because I got suspicious of some reported values I was seeing.

    Name:  sshot.png
Views: 233
Size:  11.8 KB

    Here we have a set of 3 values (Alpha, Beta, Gamma) that are simulating some sorts of "measurements" from some fictitious device. We're reporting averages of these by hour by day.

    Since we have a lot more data points it takes a lot more time than the previous example did.


    Edit

    Ok, since the performance of the reporting phase was nagging at me I went in and optimized it. Should more than 10 times as fast as before.

    Reposted attachment.
    Attached Files Attached Files
    Last edited by dilettante; Feb 25th, 2015 at 12:20 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width