Concatenating multiple fields into a single value result set

[Joshua_Moskovit]

This is a technique for creating single value results with multiple measures.

Instead of making a single query using filters and a single measure or dimension and a single value visualization for each result, return an entire row with every single value desired:

Now from this single query, we can create a single value element that contains multiple measures of data by hiding the dimensions and measures and concatenating them, be sure to hide the fields after concatenating.

This will reduce the load time used in running parallel queries on the database which uses the same WHERE filters. It can also help when designing dashboards to reduce overall tiles by consolidating similar metrics.