value loop?

[#1]

Hi

what is value loop and value list with eexamples

[jagan · Accepted solution]

Hi,

ValueLoop() and ValueList() are used to create synthetic dimensions in a chart, ValueLoop() is used to generate a numeric values dimension and ValueList() is used for both numeric and string with predefined values.

ValueLoop() and ValueList() should be used in a Calculated dimension.

Example:

=ValueLoop(1, 100, 2) - This will generate dimensional values of 1, 3,5, ....99

=ValueList('Value1', 'Value2', 'Value3') - This will generate dimensional values of Value1, Value2, Value3.

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

Check this link

Synthetic Dimensions - ValueList() (Example)

Regards,

Jagan.