Grouping values in a table

Question & Answer
, , ,
1

Hi I have a table with campaigns and conversion rate. Below are the values
A1 / 25%
A2 / 12%
B1 /20%
B2/ 21%

If I wanna group A1 and A2 together and then show the average conversion rate. Also Should have the option to drill down to see the conversion rates for A1 and A2. How to do that ? The values are grouped before.

2

Hi @liya101
you could create a calulated field
campaigns_group = left({campaigns},1)

And you could use it like (in my sample its brand_group and product_brand)

grafik
grafik783×507 33.3 KB

BR

3

Can we do this in a table? just like we group in a pivot table ?

4

i guess you cant. but you could use a pivot table as “table” (right table in the screenshot)

grafik
grafik695×486 37.9 KB