[TIP 68] Setting Up States Without Using A Measure

#1

At times, you may need to highlight some values in your data based on text rather than based on a numeric value. For example, you might have a daily report of your operations status and you wish to flag the Warning and Error status.


Starting from Dundas BI 5, you can do so by setting up states without using a numeric value in your definition. To do so, simply leave the measure selection on none, and define your condition on the dimension value you want to flag.


Here is a simple example of how it could look like:



Image title



Here is what the state condition definition would look like:


Image title
1jSIODI7R1CJdS2FZnqL_StateDefine.PNG728×621


#2

I have been wanting this so badly. But now I am sad becuase I got nothing I can see coming up to use it on and am too busy to go change the other stuff I did to use it.

#3

I know the feeling James.

Hopefully next time you do need it, you'll still remember that it can be done this way!

#4

Oh I will for sure, well now that I have said that I realy set myself up for failure havent I, LOL.


Why does spell check not work in these text boxes!!!