Forum Discussion
Visualize top 3 comparable data points to selection
I was able to solve this by creating a static table with a column that contains Selected School, Comparable #1, Comparable #2, Comparable #3. Another column with levels of L1, L2, L3, L4, and L5. I then wrote a measure where I was able to create a virtual table in a variable and generate output appropriately. I then dropped the static column into the x-axis and the the other column into the legend. The measure I created went into the y-axis. I was also able to create other measures to use as tooltips so I could show the actual school names that are returned.
Works perfectly!
I was able to solve this by creating a static table with a column that contains Selected School, Comparable #1, Comparable #2, Comparable #3. Another column with levels of L1, L2, L3, L4, and L5. I then wrote a measure where I was able to create a virtual table in a variable and generate output appropriately. I then dropped the static column into the x-axis and the the other column into the legend. The measure I created went into the y-axis. I was also able to create other measures to use as tooltips so I could show the actual school names that are returned.
Works perfectly!