Astroraf
Data Integration
Joined 02-14-2024
User Profile
User Widgets
Contributions
Re: 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 Partner49Views1like0CommentsHow 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.Solved69Views0likes4CommentsAllow 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.66Views0likes2CommentsHow to have dashboard filters affect a formula filer?
Hi DRay , I have this formula in Sisense Bar Chart: (((([Total CLAIM_CNT]) )/([Total CLAIM_CNT],Prev([@Months in DATE], 12),([@Network Name])))-1) Where I have the Category being Network Name, I also have the Network Name in the Dashboard filter but when I select a Network Name in the Dashboard filter the widget does not filter for my selected Network Name. The Network Name being in the Denominator is to get the Total Claim Count. I also know that the hierarchy for filtering in Sisense is Formula Filter > Widget fitler > then Dashboard filter. Is there anyway to override this behavior? I still need to the overall claim counts to get the percentage by individual network names but still want to filter for the specific network name.Solved
Groups
Sisense Intelligence Feedback Group
This group is dedicated to improving Sisense Intelligence through feedback and collaboration.5 Posts