Not sure if this helps, but here is how I handled a custom qualification for a date range in the above FB:
vActvieUsers="customqual='CreatedOn'>="+""""+$zFromDate$+""""+" AND 'CreatedOn'<="+""""++zToDate$+""""
Where vActiveUser is the virtual field containing the flashboard and zFromDate and zToDate are character representations of the desired date range.
The user enters the From Date Time and To Date Time then clicks on Reload and a series of active links formats the dates and ends with an active link that does the above set fields.
Works great...so simple even Vice Presidents can use it.
AR System Janitor (certifiable)
That´s a great start, though I do not see how you managed to modify several FB variables. It looks like there is only one FB variable defined collecting "active Users" over a period of time; and you change the time parameters in that custom qualification.
My challenge though is that I have several FB vars defined in one flashboard chart, and I like to modify all FB vars by applying a custom qualification that APPENDS to each FB var. As it seems, the custome qual is OVERRIDING all the qualifications of the FB vars, so they become all the same, and thereofore if displayed in the FB (chart), show the same results,
So I assume splitting your 3 variable Flashboard into 3 Flashboards of one variable each is out of the question?
2 or 3 years ago I had a document from Remedy that contained chapter and verse details on setting up flashboards and adjusting the various parameters INCLUDING customqual.
I can't seem to locate it now and 7.64 prod doc is NOT the document.
I am going to open a new discussion to see if anyone here has seen or can locate this doc.
Hi, this gets me closer to information, but unfortunately does not resolve my question. I looked at the document that was posted kindly from Barry. On page 92 ("Using dynamic qualification") is exactly what I followed through. It works great for one variable (I have a few of these flashboards designed that way), but it miserably fails at me when I have several variables in one flashboard chart, since the method overrides all variables with the same dynamic qualification.
The alternative solution I can think of is to use one FB variable, and a a way/method to assign fixed color scheme to the field value(s), e.g. when using field STATUS of an incident (HPD), that the status for the value "Assigend" is red, "In Progress" yellow, "Pending" blue, "Resolved" in green. I have seen that there is a way to actually assign these colors to these values, but if in a chart (in FB variable) a value is not present (say "Assigned" is not part of the result set to display), the colors wll STILL start with red (on value "In Progress", yellow (on value "Pending", and blue (on value "Resolved") ... which is not what I like to achieve.
Using therefore several FBvars with fixed qualification on STATUS values was working until using dynamic qualifications.
That's a shame, I thought maybe separating the qualifications with semicolons, was the "trick" you were looking for.
, but I guess that just separates the various parameters.
I have tried, in vain, to find a Flashboards guru within Remedy that might be able to resolve my issues as well as yours.
If I understand this, you get what you want IF all variables have values, but if one is missing, the color scheme is not consistent. Any chance you could test for the presence of the variables via active link and then have custom quals that meet each condition?
I have the same problem. Do you have found a solution ?