NEW
Font size
WorksheetsAnalytics: Advance Part 2
Total questions: 10
Worksheet time: 5mins
What is merge query?
Process of removing look from dashboard
Process of creating new attribute
Process of creating new calculation
Process of merging query from two existing queries or more
Which one is the correct step on making merge query?
Create based query > merge results > create another query > merge rules
Merge results > create two queries > merge rules
Create two queries > merge results > merge rules
Merge rules > create based query > create another query > merge results
Which on is the correct step to make custom measure?
Custom Field > Add > Custom Dimension
Custom Field > Add > Custom Measure
Custom Field > Create > Custom Dimension
Custom Field > Create > Custom Measure
If you want to create custom attributes that count unique values, which option you will choose?
A
B
C
D
If you want to combine values with other values, which function suitable for it?
CONCAT
COUNT
MAX
MIN
If you want to replace null value with different value, which function suitable for it?
COUNT
CONCAT
COALESCE
COS
What is the measure type that help you to count based on middle values?
Max
Min
Median
Middle
To get ratio between number of ticket solved/number of ticket created. Which expression is correct?
${ticket_updated}/${ticket_solved}
${ticket_received}/${ticket_solved}
${ticket_solved}/${ticket_received}
${ticket_solved}/${ticket_updated}
Which one the correct way to create table calculation?
Choose Customer Field > Dimension > Add calculation
Click Add calculation on data tab
Create expression on custom dimension
None from above
What is the correct data type of value "39484AD"?
Number
String
Time
Duration
