Duplicate
Duplicate calculations support date dimensions and non-date dimensions. There are two types of calculation methods for duplicate calculations:
- By Condition
- By Count
There are two types of calculation results for duplicate calculations:
- Duplicate Count
- Duplicate Rate
Duplicate calculations support specifying time fields and time filtering conditions to calculate the number of repetitions/repetition rates for specific times.
By Condition
The number of measures that meet the repetition condition will be counted for all measures under the dimension.
By Count
The count will tally the number of repetitions of the measure under this dimension. If a measure appears only once, the repetition count is 0; if it appears twice, the repetition count is 2.
- Example of Duplicate Count
- Example of Repetition Rate
Time Filter
Calculate the number of repetitions/repetition rate at a specific time.