Analytics: Advance Part 2

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