ajque
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: How to add a benchmark/trend line based on dynamic conditions to a chart?
Hello Hamza, How about if there's a break by active on my chart (by agent), but still wants to see a dynamic benchmark line (not affected by the break by), that changes week by week? I tried the above option but it deactivates automatically and retains one value once break by is activated. Thank you for any suggestions.326Views0likes0CommentsDynamic (WTD, prior WTD) based on selected Date Filter
Good Morning Enthusiasts! We have a client requirement to present WTD, MTD, QTD, YTD numbers that would be dynamic depending on the selected/active Date Filter. Example, if current filter is year 2024, they should see the latest: WTD (as of Feb 19) total, MTD (Feb 1-19) total, QTD (Jan 1 - Feb 19) total, YTD (Jan 1 - Feb 19) for now. I'm currently using the Max Date filter measure for these, however, I can't figure out yet how to show the prior WTD, MTD, QTD, YTD numbers. I attempted to use PASTWEEK(), etc. but there should be an active filter for the week itself before it works. Am I missing something? While if I use the This Week, vs Last Week filter, that would only show the current week and prior current week, and is not dynamic if I change the Date Filter. adding a sample here data here for reference, if user filters January 2024, they should see the latest WTD for January, then it will be compared to the previous week total. Any thoughts, suggestions, tips or workaround would be greatly appreciated 🙂Dynamic Pivot Columns per Dimension
Hello All! Anyone here that can share a way to apply switchable column values in a pivot table using either dropdown/button feature of blox? The idea is if I choose Dimension 1 (Channel), the columns will change to all values for Channel (e.g. Chat, Phone, Email), then if user chooses Product Type (e.g. Home, Renter, Motor), then columns will switch to values under Product Type. Below is a sample of how it can look: Would appreciate any tips you may share, have a great day!Solved2.7KViews0likes3CommentsRe: Hyperlink KPI Widget
Thanks for responding! We're hesitant to use the Jump to function as it's a little wonky. It's not as effective for our clients as they embed the original dashboard to an internal site (reports repository). Was hoping to look for a work around aside from Jump to. Anyway, appreciate your insights!3.6KViews0likes1CommentDynamic Goal Line with dropdown selection
Hello, I used a widget feature I found from binextlevel: https://www.binextlevel.com/post/filter-dropdown-in-widget and our users liked it however they want to take it to the next level and have a (dynamic) goal line added to it. Basically, every time they choose a certain metric from the dropdown, it should show the actual value and its corresponding goal, like below sample widget: The current method only selects one metric/value to show from the field of data I've set up. The code used can be found from this link: https://www.binextlevel.com/post/filter-dropdown-in-widgetLet me know if further explanation is needed. Appreciate any information that can help me with this challenge.2.3KViews1like2Comments