Report Logic for Alert Yummy lol

building reports webintelligence
1

Hi Gurus,

R3.1

I have a column we will call it food that has text word values like

Ice cream
Pie
Candy
Pudding
cake

And Lets say I have column called employee with value like john

I am trying to create an alert that states if he ate more then one food then highlight red.

Please if some one call help with the logic I do not know how I can get each distinct value and say if it has more then one value red ?

Thanks :smiley:

a123 (BOB member since 2011-12-28)

2

i’m assuming that your query results are coming in rows like this:

name food
john ice cream
john pizza

etc…

if so then you would create a block that has the name object and in the next column create a variable using formula =count[food]

then create an alerter based on the variable for the count of food

erik.stenson :us: (BOB member since 2012-07-30)

3

Ok the two columns look like this:

Column A
Food

Ice Cream
Pudding
Cake

Column b
Employee

John
Kate
Bill

a123 (BOB member since 2011-12-28)

4

yes - so create a variable called countfood and formula would be =count(food])

then create a table with employee and countfood

create an alerter based on the variable countfood >1 and do your red formatting.

erik.stenson :us: (BOB member since 2012-07-30)

5

hmmmm when i create a variable it displays same number value for each row?

a123 (BOB member since 2011-12-28)

6

is that wrong? are there people with more than one food?

erik.stenson :us: (BOB member since 2012-07-30)