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.
.png "Luminary Alumni"){kind=icon}