Cov txheej txheem:

Yuav ua li cas koj tsim cov ntaub ntawv teb hauv Formulaau hauv tableau?
Yuav ua li cas koj tsim cov ntaub ntawv teb hauv Formulaau hauv tableau?

Video: Yuav ua li cas koj tsim cov ntaub ntawv teb hauv Formulaau hauv tableau?

Video: Yuav ua li cas koj tsim cov ntaub ntawv teb hauv Formulaau hauv tableau?
Video: Playful Kiss - Playful Kiss: Full Episode 1 (Official & HD with subtitles) 2024, Tej zaum
Anonim

Tsim ib qho yooj yim xam teb

  1. Kauj ruam 1: Tsim cov xam teb . Hauv ib daim ntawv ua haujlwm hauv Tableau , xaiv Analysis > Tsim Muab xam Teb . Hauv Kev suav Editor uas qhib, muab cov xam teb ib npe.
  2. Kauj ruam 2: Sau a qauv . Hauv Kev suav Editor, sau a qauv . Qhov piv txwv no siv cov hauv qab no qauv :

Tsis tas li ntawd, koj ua li cas los tsim ib qho kev suav teb hauv tableau?

Tsim ib qho kev suav teb

  1. Hauv Tableau, xaiv Kev Tshawb Fawb> Tsim Kev Tshawb Fawb.
  2. Nyob rau hauv lub Calculation Editor uas qhib, ua cov hauv qab no: Sau ib lub npe rau daim teb xam.
  3. Thaum ua tiav, nyem OK. Daim teb tshiab suav tau ntxiv rau Kev Ntsuas hauv Cov Ntaub Ntawv pane vim nws rov qab tus lej.

Qhov thib ob, kuv yuav ua li cas thiaj tsim tau ib daim teb suav nrog feem pua hauv tableau? Teb

  1. Xaiv Kev Ntsuam Xyuas> Tsim Kev Tshawb Fawb.
  2. Sau npe rau kev suav.
  3. Hauv daim foos teb, tsim ib qho kev suav teb zoo ib yam li hauv qab no thiab nyem OK: SUM([Sales Furniture]) / SUM([Sales])
  4. Rov ua cov kauj ruam 1-3 rau txhua qhov feem pua tshiab.
  5. Tsim ib daim ntawv ua haujlwm tshiab los tso saib qhov ntsuas feem pua.

Ntawm no, koj ua li cas los tsim ib qho kev suav teb?

Txhawm rau tsim ib qho kev suav teb:

  1. Xaiv cov Fields tab, nrhiav cov pab pawg Ntxiv & Rho tawm, thiab nyem qhov More Fields drop-down hais kom ua. Nyem qhov More Fields drop-down hais kom ua.
  2. Hover koj tus nas hla Calculated Field thiab xaiv hom ntaub ntawv xav tau.
  3. Tsim koj cov lus qhia.
  4. Nyem OK.

Lub tableau siv hom lus twg rau kev suav teb?

Tableau siv nws cov lus coding. Nws zoo ib yam li SQL ntawv tab sis tsis zoo ib yam.

Pom zoo: