Astroraf
Data Integration
Joined 02-14-2024
User Profile
User Widgets
Contributions
How to Break By with Two Values
I saw this post DRay Benji_PaldiTeam but didn't seem to be resolved. Breakby with multiple Values | Sisense Community Is there a solution to this? I am trying to do a bar chart for the first value and second value to be a line chart with a breaky by. Is there a way to achieve this?How to add Scientific Units to a pivot table
Hello Sisense world, Sometimes you are working with scientific units or any units for that matter that are not available in the number formatting within Sisense. i.e. Currency values, number or percentage. With the widget edit script provided below you can add a scientific unit or any type of symbol that lets your audience know what the measure/value is being calculated by. const myTarget = { type: ['value'], values: [ { title: 'Total Quantity' // desired column } ] }; widget.transformPivot(myTarget, function(metadata, cell) { if (cell.value !== null && cell.value !== undefined) { cell.content = cell.value + " J⋅s"; } }); Here at Cause and Effect we provide a lot of useful solutions to enhance your analytics with Sisense, feel free to reach out to us to enhance your Models, Dashboard, Embedded Dashboards, etc. We have helped out hundreds of clients to produce dashboards that are easily digestable to their audience and bring their KPI's to life. Rafael Ferreira Cause + Effect Strategy [email protected] www.causeandeffectstrategy.comRe: How to Filter Dates for a date that is greater than another date?
I actually achieve this by doing a CASE WHEN statement CASE WHEN MAX(DDIFF(Goal_actual_completion_date, Goal_target_completion_date)) > 1 THEN COUNT(Goal_code) ELSE 0 END. DRay Seems like there are multiple answers to this quetion Cause and Effect Strategy Senior Data Analyst Sisense Partner199Views1like0CommentsHow to Filter Dates for a date that is greater than another date?
Hi DRay , intapiuser , JeremyFriedel I am trying to see the count of a column where the date from one field is greater than the date from another date. Here is my example: Table: Program_Plan_of_care_goal Field: Count (Goal_code) and Goal_actual_completion_date > Goal_target_completion_date I would assume I could achieve this with a CASE WHEN formula but this does not seem to get what I am looking for.Solved199Views0likes4CommentsAllow changes to be pushed from Private to Shared viewing
This really should already be an option within this feature but the fact that is not is quite maddening. When I am working on my private dashboards, there needs to be a button to push changes from the private view to the shared view to then republish the results. This should already be a feature and know that many of our clients have complained about this feature. Please please make this update sooner rather than later.Re: How to Display Category with 0 Values in Bar/Line Chart?
Hi HamzaJ The formula is total of some value lets say total emissions, I want to show all the categories even if they have a zero value. They all coming from the same table. For the formula: SUM([Total Emissions]) Assumption: (SUM[Total Emissions], ALL(Category)) -> Not sure if this would work.126Views0likes2Comments
Groups
Sisense Intelligence Feedback Group
This group is dedicated to improving Sisense Intelligence through feedback and collaboration.5 Posts