Generated from Webex transcript
Q: Does adding the commas via a string data type in this way affect the ability to sort something like largest to smallest?
A: No, because while we have string values used for labels, we still have the original numeric values that can be used for sorting. For example, you can sort industries by sales in descending order using the original numeric sales column, not the sales string column. This can be done for profit margin and quantity as well. You can also create a dynamic calculated field to sort by metric field.
Q: If you set the columns to retrieve the colors from the theme, will it cycle through the colors once the index goes beyond the number of colors in the theme?
A: This hasn’t been specifically tested, but there are ways to handle it:
- You can add more data points to your theme if needed
- You could implement alternating colors using modulo (e.g., taking the index modulo 2 to cycle between two colors)
Q: Will the item numbers always begin at zero and maintain sequential order regardless of how many fields or dimensions are added?
A: The get column references (0,1,2,etc.) will always match the order of columns as they appear in the field wells. However, when using get item, the index numbers relate to the specific columns you’ve selected with get column, not the original column numbers. For example, if you only select columns 5 and 6 with get column, get item 0 would reference the first of those selected columns (column 5) and get item 1 would reference the second (column 6).
Q: If you have NO knowledge on JSON programming, is there a page for beginners on high charts?
A: Yes, there are several learning resources available:
- Demo Central page which provides tutorials from basic to advanced concepts
- High Charts documentation page
- Getting started guides that walk through data linking basics
- Sample pages with full built-out examples that can be used as references