Skip to Content
avatar image
Former Member

Threshold Alert for spreadsheet data

I need to display the data in tabular columns, and ensure that the color of the data fields change based on a threshold to RED, YELLOW or GREEN. The challenge is that I do not see a ALERT tab for the Spreadsheet table component. Is there any other component I should use to display data which will change dynamically based on the threshold

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 24, 2008 at 09:59 AM

    Hi Patil,

    If your data range is not too large, there is a walk around that you can use overlaid spreadsheet tables (or list views) and dynamic visibility property.

    A sample solution:

    1) In embedded Excel, create copies of data range and set different colors to show alert info.

    2) Use overlaid spreadsheet tables to display each data ranges

    3) Set spreadsheet tablesu2019 Dynamic Visibility: i) bind all Status to same cell; ii) set different Keys for each component.

    4) Use a selector to insert data to the Status cell to control the visibility of spreadsheet tables.

    Thank,

    Grace Yu

    QA, Xcelsius

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 04:47 AM

    If you want a tabular display there is only two way of achieving this 1)Spreadsheet table, 2)List View.

    However in both the case alerter is not available.

    It you can represent you data in chart format(Column chart,Bar chart) then you can use the alerter function.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thankyou for the response, however is there a work around to solve this issue, as having RED, YELLOW, GREEN is a common requirement in reports, which needs to be represented in a tabular manner. I believe that Performance Manger and dashboard Builder have this functionality.