Kestrel is the built-in web server for Microsoft’s dotnetcore platform. I do not know the actual etymology of Kestrel, but it sounds like a planet or the name of some obscure band that played at Fitzgerald’s in 1997. My band never played Fitzgerald’s in the 90’s. We played the Firehouse Saloon and The Side Car Pub, but that was 2000. We had some pretty catchy tunes.
Hey DIYers: you asked and we listened, Productioneer now has a new tab for you to create your own charts. We know you love our built-in charts but you still would like to be able to create your own, we get it!
On a more serious note: any data series usually available in a canned Productioneer report or chart or dashboard will be available for plotting on your DIY Charts. The new charts templates you create can be saved, annotated, shared, cloned, printed, pickled, etc.
We know you don’t read the manual so we didn’t make one for this feature.
The video below is a quick demo, try it out or let us know if you would like more hands on training.
As usual, we appreciate your feedback so we can make it better!
Warning: Any eye damage caused by improper use of neon green or fuchsia in your DIY charts is not our fault!!!
Here is a quick tip for analyzing daily data in Power BI. If you have a query or dataset that contains a date, a category, and a value measure for that category and you want to create a static measure that always returns the total value for all categories, here is the DAX expression you would use:
DailyTotalAllCategories = CALCULATE(sum(Query1[value]),ALL(Query1[categoryname]))
You could then use this daily total DAX measure in calculation of the percentage of the total for each category with this formula:
PercentDailyTotal = DIVIDE(SUM(Query1[value]),DailyTotalAllCategories)
If you are only interested in the percent daily total you could bypass the DailyTotalAllCategories measure altogether and your formula would look like this:
PercentDailyTotal = DIVIDE( SUM(Query1[value]), CALCULATE( sum(Query1[value]), ALL(Query1[category]) ) )
Speaking in generalities can be a little hard to follow. A simple oil and gas implementation of these concepts is after the break. Continue reading “Power BI Tip: Daily Total and Percent of Daily Total DAX Expressions”
Our first Productioneer update of 2018 has been released! Version 22.214.171.124 has added lots of new data points for analysis and reporting. The official “What’s New” content is below:
Continue reading “Productioneer 126.96.36.199 Update”
For those of you not in the Houston area, the city is pretty much shutdown today due to icy conditions. We remain open, most of us wearing finger-less gloves, coding away.
Here are some pictures from the Mi4 team documenting the icy conditions around our office.
Hello readers. My name is Michael and I am a proud employee of Mi4 Corporation. January 16th of this year marks my 6 year anniversary of working at this company and I am proud to say that within this time frame I have drastically improved as both a software developer and a human being.
The pen is mightier than the sword they say, but for programmers, the keyboard is our tool of choice.
Using the keyboard is the main method we put our thoughts/ideas/code into being. One can even say that the keyboard is an extension of a programmer. With the vast array of keyboard choices, programmers can find the best fit keyboard for their workflow.
Keyboards come in various sizes that can accommodate your desk space, typing preference or aesthetic. Many are familiar with the standard or full-size ANSI OR ISO keyboards but there are other “compact” formats available. Some examples of compact keyboards:
- Tenkeyless – keyboard without numpad
- 60% keyboard – generally a keyboard without numpad and F row
- 40% keyboard – minimalist keyboard with letters and some modifiers
These compact keyboards may have programmable layers where the numeric row or F row functionality can be accessed. On some, you can create macros that can easily run scripts or simplify hotkey combos with less key presses. EFFICIENCY! Continue reading “Tools of the Trade: Keyboards”
A new history-popup feature in Productioneer allows the users to see the previous 7 days on the fly while entering field data. The new Productioneer version is scheduled to be released in mid January.
I had a previous post about Bitnami’s virtual machine offerings. What I failed to mention is that those VM images are available in VirtualBox or VMWare formats. I am partial to Hyper-V; so what’s an Mi4 developer on a Saturday night supposed to do?
Well after some searching a found a process using Powershell to convert VMWare hard drive images (vhdk files) to Hyper-v virtual hard disks (vhdx files). Continue reading “More VM Tips: vhdk to vhdx”
Coffee is still a developer’s best friend, but Bitnami is definitely in my circle of friends.
Over at Bitnami they have preconfigured virtual machines for software development. If you want to get up and running on a different software stack quickly it’s a good place to go. It’s not a bad place to spend a Saturday night either (if you’re the kind of person who lists websites in your circle of friends).
Their offerings are comprehensive, convenient, and free: WordPress, Joomla!, Elk, Rails, Tomcat, etc. And if you don’t want to spin up an entire VM, Bitnami can install the stack into an existing environment.