Solved

Metric Selector Parameter as column

  • 30 June 2021
  • 4 replies
  • 26 views

I would like to create a list of metrics as a dimension so I can create the following. I would then need to figure out how to create the second columns that does the correct aggregations. all the documentation I have found only shows the dimension as filter field only when used in a parameter, but I need it in the data pane.

 

Metric as a dimension Value

Sales

1K
Email 20
Units 10

 

icon

Best answer by antho 30 June 2021, 14:49

Hello,

Maybe, you can try to do the following,

From your explore,

1/ bring the metrics you want to expose

2/ Add a dummy custom field that you can name “value”

3/In your table settings, switch on the “transpose” option

You’ll get something like this:

 

 

Is it what you are looking for?

Antho

View original

4 replies

Userlevel 3

Hello,

Maybe, you can try to do the following,

From your explore,

1/ bring the metrics you want to expose

2/ Add a dummy custom field that you can name “value”

3/In your table settings, switch on the “transpose” option

You’ll get something like this:

 

 

Is it what you are looking for?

Antho

@antho - yes exactly what I want. Thanks for the response, will mark correct if I can get the solution to work :)

 

The custom field is it a measure or dimension

@antho do you know if you can add a second column that would do LY YTD so you could then do a table calc comparison?

Userlevel 3

@antho - yes exactly what I want. Thanks for the response, will mark correct if I can get the solution to work :)

 

The custom field is it a measure or dimension

It is a Custom Dimension because transpose requires at least 1 dimension to work ;)

Reply