ContributionsMost RecentNewest TopicsMost LikesSolutionsCalendar in Sisense I want to show individual records that exist in a month. Pivot seems only able to aggregate, table i can't define columns: So here, i would wan tthe 1 record to show the Name of hte record, if there's 4 records i would want 4 rows, or the 4 names at least displayed. This screenshot is from the paldi pivot, but its the same in the default one 😞 Merge Cells in Pivot I need to display a date/time in the pivot. I've managed this via widget script, but that makes conditionally formatting virtually impossible, as the date is not really a date (i need to colour them based on how old the record is, so i can't simply subtract 30 days) I created a second column called "indicator" based on conditions that goes 0,1,2, but now i want that indicator to be a symbol, and joined into the cell... is there a way to do this?   Re: Last Updated DAte on Dashboard (Dynamic Elasticubes_ hey Assaf! Thank you for the reply, i've tried the second script in a text widget, doesn't seem to work, is there something else i need to input? i.e you define the data sources, do i need to outline my cubes beforethe script? Re: Adding a Dropdown to Change Date Granularity in Charts is there a way to make this work for pivot tables? i.e the columns are months, but we might want to collapse it to be Quarters Re: Last Updated DAte on Dashboard (Dynamic Elasticubes_ Hey hari! Thank you for the reply, we’re using the dynamicelasticubes plugin so one dashboard will have 10 cubes viewing it depending on the user’s group. Can that cube just be an array then? Last Updated DAte on Dashboard (Dynamic Elasticubes_ I have a dashboard that i want to display at the top in a text box the lastupdated build date of my elasitube I've seen https://community.sisense.com/t5/build-analytics/show-last-updated-date-on-dashboard/m-p/3690?search-action-id=15431263853&search-result-uid=3690 But my dashboard is hooked up to many elasticubes... ideally i want the date to appear on the right hand side of this blue bar... possible? Filter out groupings with less than a certain value Similar to a sports KPI... i want 3 point shooting percentage, but only for athletes that have taken a minimum 50 shots i have a kpi that is AVG([PersonId],[# of completionId]) where completionId is how many things they've done I want to aggregate this into averages for the organization, but i need to exclude Persons who had less than 50 records.... so bassically a filter that says exclude Id's from this result where the count of their completionId is less than 50.... i can get this to work SORTOF by doing a top{x} and saying give me the top 100 by Completion#, but i want this to basically just remove any PersonIds with less than 50 Indicator text I have a list of transactions and i want to display a widget that says "Top Customer last 30 days" with the customer's name in big text. I could do this a very hacky way and have a table, filtered to the top 1 customer, but that will be very ugly... what i want is an idicator style large text widget, but i can only seem to display values... any ideas? SolvedHDIFF in Formulas when I can only group by Days... I have two dates and i want to calculate the hours between... sisense says to use HDIFF Hour Difference HDiff( <Start Time>, <End Time> ) Returns the difference between <Start Time> and <End Time> in hours. But when selecting a date field from the data selector, i can only group in years,months,days, or aggregative time... here's a screenshot of an hour diff, where the formula is all 0.... MTD, QTD compared to last year, toggle We are trying to replicate indicators we had in PowerBI, there is a lot of data in a small space here and in Sisense i'm having to build it in 4-5 different widgets to achieve the same thing: i can comepare current month to last month, or same month last year, see my totals, and % differences This is how far i've gotten in sisense indicator 😞