Select Page
Users may want to highlight the specific category which the logged in user belongs to as shown in the image below:
The following example shows how to change the color of the specific category in a bar graph according to the user who logged in:
  1. Create a database table which contains the user name and its attribute id.
  2. Create a metric, ‘User_Category’ using ‘User Login’ system prompt and define the expression as follows:
    ApplyAgg("(select max(cat_id) from DEMO_LOGIN where username=#0)", ?[User Login]) {~}
  3. Create a report and add the Category attribute and Cost metric on the template, and add the User_Category metric to the report objects.
  4. Apply a threshold on the Cost metric to compare the User_Category value and Category ID as shown in the image below:
  5. The threshold color on Cost metric is applied per the user who logged in.

TN246346: How to change the color of the specific category in a bar graph according to the user who logged in MicroStrategy 9.x?

Secured By miniOrange