Skip to content

2018

Metabase - A BI solution that just works

I like exploring new solutions and anything to do with data always piques my interest. I came across this nice tool through the list of free self hosted software.

UPDATE

I am still getting introduced to the world of docker and while most of it just works few things confuse the hell out of me.

Anyway what happened is there was an update for Metabase and I wanted to apply it on my container and in doing so I realised that some of this post can be changed to make it a better experience from get go because after update all my config and dashboards were gone and I had to reconfigure everything.

It could be that my lack of knowledge meant I did something wrong and faced the issue but irrespective doing it as per updated post below will ensure you dont face the issue at all because I have now tested it twice to ensure it works well.

Home Networking

Network routing

  1. Router - Router is the device at home that connects all devices in your house to the internet.

    1. It does so by assigning IP address to each of your device but this IP address is only relevant for devices connected to this router. What this means is that if you use an IP address allocated by this router from a coffee shop and you are not connected to your home router then you will not be able to reach the device that IP address belonged to. For this reason these IP addresses are called internal IP addresses.

MySQL Function to calculate closing WorkDay date given elapsed working time

On my post MySQL function to calculate elapsed working time I was asked in comments if the assumptions can be reversed such that given start date, starting time and closing time of site and the elapsed working hours, function should return the closed date. I was convinced that it will be possible to achieve this with minor tweaks to original logic and so I only concentrated on original code and how to tweak it to achieve the result. It is very likely that there might exist a more elegant solution but frankly I did not have a usecase I did find a usecase afterall - Clue was in redefining the problem description for this. Presented below is the function that with my minimal testing seems to give correct results. Feel free to try it and as always any feedback is welcome. 😄

Problem Description:

Find out the WorkDay date by when a ticket must be closed given:

  1. Country of site for which incident was logged.
  2. Time and Date when Incident was logged.
  3. Elapsed working hours in decimal. (Ten and a half hours as 10.5 and so on)
  4. Opening time of the site for which the incident was logged.
  5. Closing Time of the site for which incident was logged.
  6. SLA Type - Is the output date to be based purely on number of hours or based on SLA in days (eg: Next Business Day).

Assumption

It is assumed that opening and closing times are same on all working days and that all the sites are closed on holidays and weekends.