liamcameron
Cloud Apps
Joined 2 years ago
User Profile
User Widgets
Contributions
Calendar 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 😞542Views0likes2CommentsMerge 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?  638Views0likes2CommentsRe: 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?695Views0likes1CommentLast 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?834Views0likes5CommentsFilter 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 50552Views0likes2CommentsIndicator 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?Solved887Views0likes1CommentHDIFF 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....838Views1like3CommentsMTD, 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 😞1KViews0likes2Comments