threshold by various dimension

[userid128223]

Attached is the QVW for threshold problem i am currently facing.

I have:

User

date

Usage

I have create 3 input fields where user can provide threshold for Year, Month, day threshold.

I want to create a

Pivot table  => that shows 3 columns. total usage by year, by month, by day. Color of the total will be either red or green based on their above input threshold.

Chart => that shows the same thing pivot table shows.

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[userid128223]

amazing thanks. How can you show chart with same value in green & red based on selection and non selection.

[#4]

Using Gysbert's example add another "

  if(GetSelectedCount(day)=0 and GetSelectedCount(month)=0 and GetSelectedCount(year)=0,if(sum(usage)>vdailythreshold,green(),red())

Note that the day, month, year now have "= 0".  You will have to determine what criterial makes the bars green or red like in the orginal expression with the variable.

hth,

Stephen

[userid128223]

Thanks I figured that one out.

Now if I had to show only those records that exceeds certain criteria. for example show records where monthly acceds certain number.

[userid128223]

Your solution works as long as only 1 year, 1 month or 1 day is selected. Once user selected multiple months or days then the filters dont work.