ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: Filter a BloX widget to the same day of the week a year ago Benji & Daniel, Thank you both. This BloX effort has been put on hold for a bit. I let you know how this comes out once it is restarted and I can test. Regards, Jim Re: Filter a BloX widget to the same day of the week a year ago Benji, Also, we do have some filters that are in calculations. It's not clear to me how to change the code to point to the calculation filter instead of the widget filter. Can you explain? Thanks again, Jim Re: Filter a BloX widget to the same day of the week a year ago Benji, Thank you for this. I have tried on BloX and with Pivots. I followed your instructions. No joy. Can you send me your BloX templates from your example? With those I should be able to figure it out. Regards, Jim Filter a BloX widget to the same day of the week a year ago We have a requirement to filter a BloX widget to the same day of the week a year ago. Example: The dashboard filter is selected to Friday 11/24/2023 We want a particular widget to be filtered to the same day of the week last year: Friday 11/25/2022 Note: we need to take leap years into account See the screen shot below for further clarification I assume a widget script is required. Can anyone help me with this? Regards, Jim Allow new user emails for Tenants that are not SSO users I have a client that has SSO users and non-SSO users. On Sisense advice, we have created a separate tenant for the non-SSO users. We expect that those users would have all user email features of users as if SSO did not exist on the system. We are finding that the new user invitation email is not enabled for these users (among other email functions). Therefore, these users are not able to set their passwords when they are created. As a result, we are using a common password for 600+ users. This is obviously not satisfactory. Those tenant users can now log in and change their password, but we have no way to enforce that they do this as we would with an invitation email. R&D has told us this is the expected behavior (refer to case #00746676). This behavior is not working well for my client. I would like all user email features enabled for non-SSO tenants. Re: Sum of last 3 months data in Pivot Assuming you have dimACCOUNTS and factPURCHASE tables, I would create a custom column (ageFILTER) in the factPURCHASE table to use as a filter for accounts that have not made a purchase in last 3 months. That ageFILTER column code would look something like: case when [order by Date] <= addmonths(now(),-3) then 'Old' ---- Old is a row with a date older than 3 months else 'New' ---- New is a row with a purchase in the last 3 months end NOTE: using now() in the addMonths function assumes your data is updated through today. If you build once a day and your ElastiCube data is updated through yesterday you can adjust for this by using addmonths(adddays(now(),-1),-3). This subtracts a day from now. On my dashboard I would create a pivot table with a row column listing ACCOUNTS. I would then create a widget filter based on my new ageFILTER column. The ageFILTER column will have values OLD and NEW. Unselect the NEW value. That should leave customers who have only OLD values. They will not have made a purchase in the last 3 months. Hope this helps, Jim Re: Exclude one group from viewing dashboards There's no way to exclude a group from seeing certain dashboards. Your approach of a new group, etc. is the way to go. You can use the built-in Swagger REST API interface and the 1.0 endpoint patch/users/bulk to add your existing users to the new group. Export a list of your user using the 1.0 endpoint get/users, with the fields value userName. That will give you the user list JSON you can download. You will also need to get the groupid of your new group using the 1.0 get/groups endpoint. Once you have it, use a text editor or development tool to add the groupid to your downloaded user list json using search/replace. Note that the groups JSON in the patch command is nested in a list so you will need to add [ ] (like this: "groups": ["648a1a463e2c74002d6c4eb2"]) around the value in your final JSON. You're now ready to paste your final JSON into the patch command panel and execute it. Hope this helps, Jim My Sisense Journey from Customer to Implementation Partner In the fall of 2013 and winter of 2014, I spearheaded a rigorous BI evaluation process for an energy analytics company. This post describes why I selected Sisense, my Customer journey, and then my Implementation Partner journey since the fall of 2018. Re: Dashboard Duplication without connection to Original Dashboard Dane - not sure what you are seeing, but there are no dups with references. Duplicate always creates a new dashboard with a new GUID. Regards, Jim Re: Days Since [Days in Date] Issue - Unexpected token With the new Analytical Engine you don't use the date variable with NOW. Your ex. DDiff(NOW(),[Days in date]) except you have to wrap the DDiff in an aggregation. Ex. avg(DDiff(startTime, NOW())) Hope this helps, Jim