Date Filters - List
I have a dashboard that looks at diversity and demographic information for my company, and a key piece of its functionality is the ability to select a specific month/year so our users can view information from any number of points in time. The way I currently have it set up is that it is a month filter and a radio button - so only one month can be selected and displayed at a time. My question is that as time goes on, new months will be populated and placed at the top of my filter list - is there a way to have the filter default to the most recent date in the filter? For example, when I designed this in Feb 2024 I set my default filters to that date. When March 2024 was populated, the default filter stuck on February 2024 - ideally, I would like the default filter to roll up to the most recent available date. Has anyone encountered this before/have a solution besides updating the default filters every month?2.4KViews0likes4Comments
Export to PDF Customise
Hello, I would like to know if there are any best practice on creating a dashboard which will give me a clean pdf export currently, my basic charts are distorted and divided into 4 separate pages blox widgets are of uneven sizes Widget titles are exported even though I have hidden them on the dashboard level I am not using any tabbers here if there is a script I can use to customize the export and make it look cleaner it would be very helpful thank you2.2KViews0likes2Comments
Number per year where a different date is within a year of the first
I was creating a dashboard for someone, and one of the widgets was a column chart that plotted out the number of people per year of hire. So, x-axis is the year of hire from left-to-right, then each column is the number of people who were hired that year. So far so good. I was asked if we could filter the chart so it only shows people who also had a different date occur within a year of them being hired. In other words: can we focus on just the new hires? Not the new hires right now, but people who were new hires at the time that this second date occurred. Let's call the first date (that I'm plotting by) "Hire Date" and the second date (that I want to filter by) "Opened Date". As far as the data is structured, these are on different tables and can be a one-to-many situation (i.e. a given person only has one hire date but may be associated with multiple records and thus have multiple Opened Dates). At first I thought this would be relatively simple. I added a new measure and used the following formula: DDiff([Days in Opened Date],[Days in Hire Date]). Then I thought "all I need to do is filter for the ones that are 365 or less". This didn't work. Let's say a given year originally showed 10 people, and out of those, 5 were a "new hire" at the time they had an Opened Date (i.e. the other 5 people had Opened Dates that were after their year of hire). However, when I added my formula and then applied the filter, the amount would change to something much higher, like 47. When I change the view to something else like Table, it becomes clear that the filter is somehow duplicating rows when its present, but I don't understand why. If i deactivate/remove the filter then the duplicate rows go away, but then obviously I'm not getting the filtering that I need. I also tried using a conditional formula. Something like: IF( DDiff([Days in Opened Date],[Days in Hire Date]) < 366, 1, 0). My hope was that, if this worked, then I could simply filter for the records that resolved to "1", and I could get proper counts by summing all the 1's. Unfortunately I keep on getting an inscrutable error message that says "Error in function definition (IF) in the 'condition': Expecting parameter of type 'Boolean' that consists of expression types 'Member Expression'. Instead found 'Dimension Expression'." This doesn't make sense to me, since why would "DDiff([Days in Opened Date],[Days in Hire Date]) < 366" NOT be a boolean? "DDiff([Days in Opened Date],[Days in Hire Date])" itself will always resolve to some sort of number, so we should always have something to compare to "366", and thus we should always be able to respond TRUE or FALSE, right? In any case, does anyone have a good way of achieving the sort of filtering I need to do? PLEASE NOTE: I do not have access to our eCube configuration, so any solutions that involve modifying the eCube or creating any new columns in the eCube are non-starters for me. Thanks!Solved2.7KViews0likes3CommentsWrong range in dynamic buckets
hello I am using dynamic buckets to show number of customers in each spend range for the selected time period, I am using the dynamic bucket plugin. My issue is the highest bucket range i.e. 800 is wrong as the maximum spend I have in my view is 741 and due to this when I change the dates on the dashboard sometimes my highest bucket shows number of customer as 0. is there a way I can edit the bucket ranges without making it manual. So ideally my maximum spend per customer in selected time period is 741 so my bucket range should be as follows 0 to 148 148 to 297 297 to 445 445 to 593 593 to 741 I cannot make this manual as the dashboard is per brand and also has a date filter as mentioned above so the maximum spend is going to be different for different selections. any help will be appreciated thank you2.1KViews0likes2CommentsCustom Blox Filter for measure
Hello, I was wondering if there is a way to create a measure filter in my case customer spend filter, where the user can define a number and the views are filtered by it? so basically I want to filter my view for customers who spent more than XYZ number. I want to give my users the ability to input there number932Views0likes0CommentsAccumulateBy with Connection change
Hi Team, I have cube with 800M rows and it is currently building incrementally. I got scenario where my DB source upgraded and I should change my connectivity of cube. What should happens if build a schema build? will my build bring only latest data or do we need to go with a full build? How we can avoid complete build? Please help to understand what will happen to accumulate build when we change the connection string. Thanks NH888Views0likes0Comments
Calculating overtime in pivot table
Hi all, I'm not sure why I'm not getting the right value of overtime per employee when i remove the column week. We calculate the overtime on a weekly basis. Basically an employee has an overtime when the sum of his punched hours (the hours he worked for the week) + the sum of his vacations days ( 8 hours per day if he has vacations for a specific week) + the sum of holiday hours ( 8 hours per day if there's a Holiday for a specific week) is less than 48 hours. Here is an example for the employee ID 30028 : He worked for week 35 , 39.63 hours + he had one vacation day (8hours) , total = 47.63 < 48 , so overtime = 0 For week 36 he worked 48.47 hours , so he has 0.47 hour in overtime. But HR team wants to see the overall total of overtime for a given day period (we're using a calendar filter) without having to do the calculation manually. So when i remove the column week , i get 0.1 in overtime , which is not the correct value. It's like it's doing (47.63 + 48.47) - 96 , which is 0.1 overtime. Instead of 47.63 < 48 so overtime = 0 + 48.47 > 48 so overtime = 0.47 , total = 0.47. Here is my formula : CASE when (SUM([Total Punched Hours]+[Total Vacation Hours]+[Total Holiday Hours]),[Week]) < (SUM([Total Hours day]),[Week]) then 0 else (SUM([Total Punched Hours]+[Total Vacation Hours]+[Total Holiday Hours]),[Week]) - (SUM([Total Hours day]),[Week]) END Thanks for the help,Solved2.5KViews0likes2Comments