mmalhame
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Create a % Contribution Over Time Calculation
I am trying to create a stacked bar chart view that shows the % of each category, for each date, over time. However, when I try to use the contribution function, the % values returned are calculated for the entire period, not per date. For example, for the month of 04/2023 the number of "No" users was 171 and the number of "Not Decided Yet" users was 272. I want the chart to show 39% for "No" and 61% for "Not Decided Yet". Instead, the chart shows 10% for "No" and 8% for "Not Decided Yet". The formula being used is simply: contribution(COUNT([case_id])) Is there any way to get the view I want?Solved1.8KViews0likes4CommentsRe: Conditional Color Formatting by Dimension / Row Combination in Pivot Table
Thanks Hamza. Can you help me understand where I would input the HTML code? Is it using the 'Edit Script' button within the widget? Also, I would like the background 'highlight' color within the cell to be red or green, not the font itself. How would that change the HTML code you shared?1.4KViews0likes0CommentsConditional Color Formatting by Dimension / Row Combination in Pivot Table
I would like to conditionally format a pivot table depending on the combination of 2 dimensions in the view. For example, in the screenshot below, I would like to color 'Bindable Ready to Quote' and 'cold' or 'open' green, and 'Bindable Ready to Quote' and 'pending' or 'solved' as red. Then I would like to color 'Complete Navigator' and 'cold' as green, and 'Completed Navigator' and 'open', 'pending', or 'solved' as red. Is there a way to code in specific combinations of dimensions as colors in the view?1.5KViews0likes7CommentsHow to Use the SwitchDimension Add-On
I am trying to create a line chart for which users can select the 'Break by' dimension. The user should be able to select whether to break out the line chart by choosing 1 of 2 different text fields. Each text field has a handful of different values. I have enabled the 'SwitchDimension' add-on in the Admin settings. It is running on version 1.0.8. I have had difficulty finding documentation on how to use this add-on. I think the technical details found here are the right instructions, but I'm not sure. When I follow those instructions, and use the below script in the widget, nothing happens. I'm not sure what I'm doing wrong, can someone help? prism.registerSwitchDimension({ widget: widget, maxItemsBeforeSubMenuIsCreated: 5, //optional dimensions: [ { panel: 'break by', affectAllWidgets: true, //optional (true|false) dims: [ { "index": 0, "dim": "[everly_workitemdays_view.applied_rate_class]", "datatype": "text", "title": "Applied Rate Class" //optional //"widgetTitleTemplate": "" //optional }, { "index": 0, "dim": "[everly_workitemdays_view.approved_rate_class]", "datatype": "text", "title": "Approved Rate Class" //optional //"widgetTitleTemplate": "" //optional } ] } ] });Solved987Views0likes2Comments