Skip to main content
Question

Hello everyone, I would like to create a benchmark sheet in a View, but do not understand how to use the created variables in the right way. Someone has experience with this? Thanks a lot!

  • December 12, 2022
  • 1 reply
  • 10 views

Forum|alt.badge.img+7
Hello everyone, I would like to create a benchmark sheet in a View, but do not understand how to use the created variables in the right way. Someone has experience with this? Thanks a lot!

1 reply

1.Create selection criteria variables:

benchmark_value

benchmark_text

 

2.For first and second selection criteria create separate variables

benchmark_2_text

benchmark_2_value

 

benchmark_1_text

benchmark_1_value

 

3.Use component filters for KPIs, etc.

FILTER <%=benchmark_value%> IN (<%=benchmark_1_value%>);

FILTER <%=benchmark_value%> IN (<%=benchmark_2_value%>);