Metabase: Menambahkan Interval Waktu (Date_add)

-
Date_Add in Metabase
Date_Add in Metabase dan BigQuery

Jadi alasan kenapa saya menulis ini adalah karena, saya menemukan banyak versi terkait cara menggunakan dateadd dari sumber online. Ini tentu berbeda dari satu platform ke platform lain. Nah kebetulan saya menggunakan BigQuery di kantor saya, dan tidak banyak sumber online yang memuat sumber ini.

Namun, sebelum saya menjelaskan cara penggunaannya, aku jelaskan lagi penggunaan dateadd ini. Nah dateadd ini berfungsi untuk mengubah/mengedit data waktu (a.k.a timestamp) sesuai dengan yang kita inginkan. Misalnya, kita ingin mengubah keterangan waktu dari suatu atau beberapa baris, kita bisa menggunakan dateadd ini.

Untuk di metabase, bisa gunakan rumus berikut:

Date_add(nama_kolom, interval [Angka] [keterangan waktu])

Contoh: Select
                    date_add (b.month, interval 1 month)
                    as rr_month
              from rr join b on dst..

Keterangan: b.month = b adalah nama table nya, dan month adalah nama kolomnya
                     1 = indikator angka
                     month = indikator satuan waktu yang diinginkan

Perlu diingat b.month diatas jenis datanya mesti menggunakan tipe tanggal ya.


Fungsi date_add ini dapat dipakai untuk membandingkan antara data yang sebenarnya dengan data jika data yang sebenarnya diterapkan pada waktu yang diinginkan.

Contoh praktisnya adalah, kamu diminta untuk mencari berapa sih presentase data user yang reactivated bulan lalu, kemudian kembali lagi di bulan ini.

Kamu ada kendala apa di metabase? Yuk diskusi di kolom komentar!

Comments

Post a Comment

Popular posts from this blog

IELTS Writing Task 1 - Process

-
Image
  Question: The diagram below shows the process for recycling plastic bottles. Summarise the information by selecting and reporting the main features, and make comparisons where relevant. Answer: The flowchart illustrates the process of plastic bottles recycling. In general, the process of recycling involves at least 9 steps from collecting the bottle all the way to ready to use products such as fabrics or a new plastic. It all starts from waste bin where all waste is collected. The content of waste bin is carried using truck to recycling centre where waste is sorted according to its type. At this point, plastic bottles are collected then compressed into blocks to ease the transportation. These blocks then transported to another plant where the plastic blocks are crushed and washed. This makes plastic clean and smaller in size that ready to be used as ingredient of producing plastic pellets. In order to create raw material, the plastic pellets are heated to from in a special shape.
Read more

IELTS Academic Writing Task 1 - Map

-
Image
  Question:  The plans below show the site of an airport now and how it will look after redevelopment next year. Summarise the information by selecting and reporting the main features, and make comparisons where relevant. Answer: The maps illustrate the changes of southwest airport from existing layout to after development. Overall, there will be several expansions and features and facilities added inside the airport. There will be two expansions built in the airport. First, the waiting room. Southwest Airport will have 10 additional to gates from only 8 gates now to 18 gates after development. The area will be also larger with the extension to northwest and northeast so that it will look like a V shape. Sky train will be built to support travelers to ease mobilization. Small section of the arrival hall is also added and will be used for car hire. Other then sky train, there will be also bag drop located at the left-upper corner departure hall. It will replace the check-in counter
Read more

IELTS Writing task 2

-
 Writing Task 2 Question: In some countries, more and more people are becoming interested in finding out about the history of the house or building they live in. What are the reasons for this? How can people research this? Answer: There is increasing interest of home owners all around the world to get to know about the history of the building they live in. This curiosity gives some benefits one of them is to know the age of the building knowing how old the building will help the home owners to identify the need of reconstruction. Some buildings are designed to last a few years, and get the exact number of age of the building will the determine the house is rebuilt or abolish. Another advantage is understanding the surrounding cultures and changed that happen along. Many building started with humble beginning and turn to urban areas as the population grow. It might also change the culture that follow the ethnicity that live there. Many areas starts from a single ethnicity and becomes di
Read more