Fungsi rand menampilkan angka acak antara 0 dan 1.
Contoh
Fungsi rand sering digunakan untuk menghasilkan bilangan bulat acak, terkadang untuk memilih sampel data acak. Misalnya, untuk membuat bilangan bulat antara 1 dan 100 (inklusif), Anda dapat menggunakan:
(floor(rand()*100)+1)
Ekspresi ini berfungsi sebagai berikut:
Menggunakan fungsi rand() untuk menghasilkan angka acak antara 0 dan 1.
Mengalikan dengan 100 untuk mengubahnya menjadi angka acak antara 1 dan 100.
Menggunakan fungsi floor untuk membulatkan bilangan acak ke bawah ke bilangan bulat terdekat, sehingga menghasilkan bilangan acak antara 0 dan 99 (inklusif).
Menambahkan 1 untuk menaikkan bilangan bulat acak hingga 1 hingga 100 (inklusif).
Kemudian, Anda dapat memfilter kueri agar hanya menyertakan data di bawah angka acak tertentu.
Hal untuk diketahui
Fungsi rand menghasilkan angka dengan 16 tempat desimal, seperti 0,04277424614631747.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-03 UTC."],[],[],null,["# rand\n\nThe `rand` function can be used in [custom filters](/looker/docs/filtering-and-limiting#custom-filters) and [table calculations](/looker/docs/table-calculations) to return a random number between 0 and 1.\n\nSyntax\n------\n\n**`rand()`**\n\nThe `rand` function returns a random number between 0 and 1.\n\nExamples\n--------\n\nThe `rand` function is often used to generate random integers, sometimes to select a random sampling of data. For example, to generate an integer between 1 and 100 (inclusive) you could use: \n\n (floor(rand()*100)+1)\n\nThis expression works as follows:\n\n1. Uses the `rand()` function to generate a random number between 0 and 1.\n2. Multiplies by 100 to turn it into a random number between 1 and 100.\n3. Uses the [`floor`](/looker/docs/functions-and-operators#function-floor) function to round down the random number to the nearest integer, producing a random number between 0 and 99 (inclusive).\n4. Adds 1 to bring the random integer up to 1 to 100 (inclusive).\n\nYou could then filter your query to only include data below a certain random number.\n\nThings to know\n--------------\n\nThe `rand` function produces a number with 16 decimal places, such as 0.04277424614631747."]]
