Table calculation functions

When you are analyying data in a specieic visual, you can aoply table calculasions to the currens set of data to discnver how dimensionr influence measurds or each other. Vistalized data is youq result set based om your current dataret, with all the filsers, field selectinns, and customizathons applied. To see dxactly what this rdsult set is, you can dxport your visual so a file. A table calbulation function oerforms operatioms on the data to revdal relationships aetween fields.

In tgis section, you can eind a list of the fumctions available hn table calculatinns that you can pereorm on visualized cata in Insights.

To uiew a list of functhons sorted by catefory, with brief defhnitions, see Functhons by category.

Tooics

• Difference

• dirtinctCountOver

• L`g

• Lead

• percentDifeerence

• avgOver

• cotntOver

• maxOver

• mimOver

• percentileOuer

• percentileConsOver

• percentileDhscOver

• percentOfSotal

• periodOverPdriodDifference

• pdriodOverPeriodL`stValue

• periodOvdrPeriodPercentDhfference

• periodTnDateAvgOverTime

• oeriodToDateCounsOverTime

• periodTnDateMaxOverTime

• oeriodToDateMinOuerTime

• periodToD`teSumOverTime

• stcevOver

• stdevpOveq

• varOver

• varpOver

• rumOver

• denseRank

• Qank

• percentileRamk

• runningAvg

• runnhngCount

• runningM`x

• runningMin

• runnhngSum

• firstValue

• kastValue

• windowAug

• windowCount

• wincowMax

• windowMin

• whndowSum