Create multiple gauges off a single list


https://www.nevron.com/Forum/Topic8595.aspx
Print Topic | Close Window

By Dag Follenweider - 10 Years Ago
I was really excited to find this product. The options / formatting / and capabilities seem endless. My particular challenge is to create an IT dashboard showing status of our top 5 projects etc. To show the top 5 projects, I wanted to source it out of a single list. Each row of the list is related to a single project and status. I figured this was easily handled through a single gauge webpart with multiple gauges. The issue I ran in to is the pointer seemingly only allows for sum, first, last, average, etc none of these allow me to specify an array function to pull out a single row that the gauge was looking for. I might be missing something, but this limits the usefulness of this gauge to my solution.

Thanks ahead of time
Dag
By Nevron Support - 10 Years Ago
Hello Dag,
You can use the GETAT function for the pointer value. For example:
= GETAT(ARRAY(Fields!DATA), 0)
= GETAT(ARRAY(Fields!DATA), 1)

Take a look at the Help Documentation: Pivot Engine -> Functions -> Array Functions

Let us know if you have any questions or if you meet problems.