The inter row computation is quite common, such as the aggregate, comparison with same period of any previous year, and link relative ratio. Both R language and esProc provides the pretty good inter-row computation ability with slight difference to each other. In the below case, the utilization of some basic inter-row computations is demonstrated to study on the differences between the two methods:
A sales department of a company wants to make statistics on the outstanding sales persons, that is, the sales persons achieve half of the total sales of the company. The data are mainly from the order table
of MSSQL database salesOrder. The main fields include the ID of order: ordered, Name of sales person: name, Sales amount: sales, and date of order: salesDate.
The straightforward solution is as shown below:
1.Group by sales person to calculate the sales amount of each sales person.
2.Sort by sales amount in reverse order on the basis of the data from the previous step.
3.According to the previous step, calculate the aggregate value of each record, and calculate the standard of comparison: the half of total sales of this company.
4.Of the aggregate values calculated in the previous step, select out...(Read whole news on source site)
I recently blogged on a feature I worked on, custom search commands for Splunk using our Python SDK. Custom search allows you to extend Splunk’s search language with new commands that can do things like apply custom filtering, perform complex … Continue reading →
Windows Phone 8.1 has been released for developers, and will be available for all soon.
Of course you can already find great in detail reviews of Windows Phone 8.1:
http://www.wpcentral.com/windows-phone-81-review or this nice video tour of its new features:
https://www.youtube.com/watch?v=a4Bygaqp3Wk&feature=share Here I want to focus on the new features that help me boost my productivity since I installed the update on my phone. Settings
“Show more Tiles” (now for non 1080p phones) increase tiles density on your start screen, more tiles = more tasks done quickly. “Sync my settings” across devices, particularly interesting in IE where you can see tabs opened in your other devices. “Project my screen” (TV, PC, projetor), this feature *will* allow you to mirror your screen to an external display, wirelessly using Miracast technology and *new* WP8.1 hardware, or via USB but we need to wait for the desktop app to be released by MS first. So it is not there yet, but it...(Read whole news on source site)
According to Maarten Balliauw, Building .NET projects is a world of pain. He should know, he is a co-founder of MyGet.org which provides private NuGet feeds along with build services for those packages. He's also a co-author of the Pro NuGet book, though I might argue he's most famous for his contribution to Let Me Bing That For You. His post gives voice to a frustration I've long had. For example, if you want to build a project library that targets Windows 8 RT, you have to install Visual Studio on your build machine. That's just silly
fries! (By the way, if you have a solution that doesn't require Visual Studio, I'd love to hear it!) Maarten doesn't just rant about this situation, he proposes a solution (emphasis mine): I do not think we can solve this quickly and change history. But I do think from now on we have to start building SDK’s differently. Most projects only require an MSBuild .targets file and some assemblies, either containing MSBuild tasks or reference assemblies, to do their compilation work. What if… we shipped the minimum files required to succesfully build a project as NuGet packages? This philosophy aligns well with my...(Read whole news on source site)
Okay, you've had a week to digest all the video content from Build 2014? Done yet? Me, neither. Well, how about some tricks to make this easier? I'd written up a few tips and tricks for catching up on Channel 9 event videos back in 2011, this is an update circa 2014. Trick 1: Subscribe and watch at high speed in VLC There are a lot of sessions, and watching even at 10% faster makes a difference. I think you'll be surprised at how, with a little practice, you can keep cranking the speed up and absorb
the content at 2x or even faster. Note: Every time I tell people about high speed playback, people assume it's going to make the speakers sound like chipmunks. All of the high speed playback options I'm going to show are pitch corrected, so they don't raise the speakers' voices. If you don't have VLC installed, I highly recommend it. It's lightweight and has a minimal interface, but is packed with codecs and advanced features when you need them. You can install via Chocolatey (cinst vlc), directly from http://www.videolan.org/, or from http://ninite.com. Run VLC and pop...(Read whole news on source site)
I’m excited to announce the launch of SonicAgile 2.0 which is a free Agile Project Management tool. You can start using it right now (for free) by visiting the following address: http://sonicagile.com/ What’s special about SonicAgile? SonicAgile supports a real-time backlog and kanban. When you make changes to the backlog or kanban then those changes […]