Laflet
Cloud Apps
Joined 3 years ago
User Profile
User Widgets
Contributions
PASTYEAR function issue with leap years
Hello Sisense Team, I encountered an issue while using the PASTYEAR function in a column chart with date/month as a category. Specifically, I noticed that there is no data displayed for February 29th from last year. I assume this is because the current year isn't a leap year. Could you please advise on how to resolve this issue? I'm looking to return the current year's values split by months, alongside last year's values. Last year's values should display regardless of whether or not i have a value this year. Any guidance or solutions would be greatly appreciated! Thank you.16Views0likes1CommentFiltering Inventory Dashboard to a Specific Date Using dbt Snapshot (valid_from/valid_to)
Hi Sisense Community, I'm working on an inventory dashboard in Sisense and I'm using dbt Snapshots to maintain historical inventory data. My snapshot table includes dbt_valid_from and dbt_valid_to columns to track the period for which each inventory record was valid. I want to enable users to filter the dashboard to a specific date and see the inventory position on that exact day. For example, if a user selects "12/04/2025" (April 12, 2025), the dashboard should display the inventory levels as they were on that date, based on the dbt_valid_from and dbt_valid_to ranges. My inventory_history table in the ElastiCube has the following relevant columns: product_id location_id quantity_on_hand dbt_valid_from (Date/Timestamp) dbt_valid_to (Date/Timestamp, can be NULL for current records) I'm looking for the best way to implement a filter that allows users to select a single "Inventory Position Date" and then filter my inventory widgets to show only the records where the selected date falls within the dbt_valid_from and dbt_valid_to range (or dbt_valid_from is before the selected date and dbt_valid_to is NULL). Specifically, I'm wondering: What is the best approach to allow users to select a single date for this filtering? How would I create the necessary logic (likely a Calculated Field) in the ElastiCube to determine if an inventory record was valid on the selected date? I need to compare the selected date with the dbt_valid_from and dbt_valid_to columns, handling the NULL value in dbt_valid_to for current records. How would I then use this calculated field (or another method) to filter my inventory widgets to show the correct data for the selected date? Any guidance, examples of calculated field formulas, or best practices for implementing this type of point-in-time filtering in Sisense would be greatly appreciated! Thanks in advance for your help.Solved614Views0likes4CommentsRe: Pivot2: "Clickable URL Links In Pivot Rows" Re-Implemented
What’s the advantage of this method compared with: https://community.sisense.com/t5/knowledge/clickable-url-links-in-pivot-rows/ta-p/9592 Personally, i would have thought that enabling “Allow rendering Pivot Table content as HTML“ would be preferred.1.1KViews0likes0CommentsRe: Folder and Dashboard Ownership for Multiple Users
qamardinpal Might be worth looking at this plugin. Given it’s currently not on the road map, this is likely what i will do. https://www.sisense.com/marketplace/share-folder/?categories=all&type=addons&publisher=all&cost=all&sort=A-Z&searchString=folder3.6KViews0likes0CommentsRe: Folder and Dashboard Ownership for Multiple Users
For development purposes, co-owning dashboards will be beneficial for non admin users. But for folder management, co-owned folders would be great. Is it possible for admins to change the owner or view as owner in a folder, a bit like in dashboards?3.6KViews0likes0CommentsRe: Folder and Dashboard Ownership for Multiple Users
DRay Could you provide further guidance on whether this will include folders? In the current structure, the owner of the folder has to add dashboards into said folder. I’d like to allow multiple users to add dashboards into folders. This would be super beneficial for workflow.3.7KViews0likes0CommentsRe: Calculate the Month Difference Between Min and Max Date Fields from the Dashboard (without scrip
this should get you Day diff. It assumes a 30-day month and doesn’t account for edge cases, such as leap year, etc. ((FLOOR(max([Date Numeric])/10000) - FLOOR(min([Date Numeric])/10000)) * 365) + ((FLOOR((max([Date Numeric]) - 10000 * FLOOR(max([Date Numeric])/10000))/100) - FLOOR((min([Date Numeric]) - 10000 * FLOOR(min([Date Numeric])/10000))/100)) * 30) + ((max([Date Numeric]) - 10000 * FLOOR(max([Date Numeric])/10000) - 100 * FLOOR((max([Date Numeric]) - 10000 * FLOOR(max([Date Numeric])/10000))/100)) - (min([Date Numeric]) - 10000 * FLOOR(min([Date Numeric])/10000) - 100 * FLOOR((min([Date Numeric]) - 10000 * FLOOR(min([Date Numeric])/10000))/100))) Any idea how to deal with those edge cases?1.4KViews0likes0Comments