# Hvordan opprette datamodeller

### Finne frem

* Gå til hovedmenyen og klikk på **"Datamodeller"**\ <br>

  <div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FjGrIoSjJQPpZghJpVNlW%2Fimage.png?alt=media&#x26;token=b1df87a7-75ea-4e11-8448-036a71506a8b" alt="" width="207"><figcaption></figcaption></figure></div>

* Klikk på **"Ny datamodell"** øverst på venstre side:<br>

  <div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2Fl5PlzpDTbm6shbzYkyGJ%2Fimage.png?alt=media&#x26;token=2843c477-48cf-4573-abc6-5e16f6602a0d" alt="" width="150"><figcaption></figcaption></figure></div>

## Opprett datamodell&#x20;

#### Last opp Excel-fil

* Dra inn eller velg en Excel- eller CSV-fil øverst i skjemaet som dukker opp:

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2Fkc6a2joj96U3Q0KuKKr0%2Fimage.png?alt=media&#x26;token=e799f08f-4aa7-4ccc-a2d7-597f6d094966" alt="" width="375"><figcaption></figcaption></figure></div>

* For at importen skal fungere, må tabellen i Excel starte på celle A1 i Excel-arket:

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FOpEhUhMkAv0zrPNF5iEs%2Fimage.png?alt=media&#x26;token=e7105ebe-83f1-4724-8124-9961b96bd727" alt="" width="563"><figcaption></figcaption></figure></div>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2Fq7KhF8lCMVuBQqTlVWlN%2Fimage.png?alt=media&#x26;token=75f97c98-3bbe-4db7-b437-01e3f750265f" alt="" width="563"><figcaption></figcaption></figure></div>

* Systemet leser filen og oppretter kolonner automatisk: det blir vist en forhåndsvisning av kolonnene som er funnet:

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FbwcV232i0xxO6ObBAOyn%2Fimage.png?alt=media&#x26;token=1cb8a5f8-c6bf-489c-a009-6b9d279b66ae" alt="" width="563"><figcaption></figcaption></figure></div>

### Juster kolonner

Du kan gjøre endringer i kolonnene ved å:

<details>

<summary>Endre navn</summary>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FzeezrlWe9IzKugsQwvqU%2Fimage.png?alt=media&#x26;token=4c0274b6-a7a0-4b73-bf8e-6f28646defaf" alt="" width="563"><figcaption></figcaption></figure></div>

</details>

<details>

<summary>Velge datatype</summary>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FcIs4dakoFxCUKxjk7EBV%2Fimage.png?alt=media&#x26;token=ede8b179-818c-43f6-b402-d8ca51cfa5b1" alt="" width="563"><figcaption></figcaption></figure></div>

</details>

<details>

<summary>Legge til eller fjerne kolonner</summary>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2Feww2tBHBv6Yf4GDUR8rm%2Fimage.png?alt=media&#x26;token=ec86d360-f076-4b5b-bf1b-a1e75d1f3aa4" alt="" width="563"><figcaption></figcaption></figure></div>

</details>

<details>

<summary>Endre rekkefølge</summary>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2F7QQpmKWYxJ4YAKwnnyT2%2Fimage.png?alt=media&#x26;token=98de374d-8306-4643-afa7-dac90365e360" alt="" width="563"><figcaption></figcaption></figure></div>

</details>

<details>

<summary>Sette som påkrevd</summary>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2Fe0K8eDv7NGaezDk1mdxS%2Fimage.png?alt=media&#x26;token=62edc585-4a27-434f-ba9e-a85149ff419c" alt="" width="563"><figcaption></figcaption></figure></div>

</details>

<details>

<summary>Skjule kolonner som ikke skal vises</summary>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FxTBw4bnwZq1eiPJsGBM8%2Fimage.png?alt=media&#x26;token=82dcf573-641f-451e-9bba-65920f2691fe" alt="" width="563"><figcaption></figcaption></figure></div>

Kolonner som er satt som skjult, vises ikke i tabellen for brukere med lesetilgang, men er fortsatt synlige for de som kan redigere datasettet.

</details>

<details>

<summary>Sette kolonne som unik</summary>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2Fxy8jt0IdjZyCUEJS0aDa%2Fimage.png?alt=media&#x26;token=f4c42eb5-16f7-47cc-b763-e403038cb8ae" alt="" width="563"><figcaption></figcaption></figure></div>

Brukes til å sikre at verdier ikke dupliseres i en kolonne. Dette gjør det enklere å unngå feil og sørger for at hver rad kan identifiseres entydig.

</details>

<details>

<summary>Velge aggregering</summary>

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FAsTCEq45SidKfl1DUAMd%2Fimage.png?alt=media&#x26;token=9ab1eb7d-ca1d-4eb1-a03e-d8df5b490154" alt="" width="563"><figcaption></figcaption></figure></div>

Brukes til å oppsummere verdier i en kolonne. Oppsummeringen kan beregnes som sum, gjennomsnitt, minimum eller maksimum, og vises nederst i tabellen.

</details>

### Opprett&#x20;

* Gi datamodellen et navn
* Legg til farge ved å klikke på sirkelen i navnefeltet:

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FImzzg9bSkFpzvFp1a7If%2Fimage.png?alt=media&#x26;token=53ea4b87-7206-4c19-85f0-876cf7757ccd" alt="" width="375"><figcaption></figcaption></figure></div>

* Legg til en beskrivelse (valgfritt)
* Velg unik identifikator
* Klikk på **"Opprett"**

<div align="left"><figure><img src="https://3216209513-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6aWzMnk8Uk6WDJJWUE46%2Fuploads%2FSozrsR37XxBXpxiW1tV1%2Fimage.png?alt=media&#x26;token=31ad26bb-c00a-46cf-93ff-4e1153bc46f4" alt="" width="375"><figcaption></figcaption></figure></div>