Skip to main content
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.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%>);


Reply