ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: 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 Partner How 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. SolvedRe: How to add user from Auth 0 into Sisense? The client is trying to have the users they already created from Auth0 input into Sisense DRay Re: How to Display Category with 0 Values in Bar/Line Chart? Hi DRay , The answer provided did not provide I solution. I will try a support ticket. Allow 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 have dashboard filters affect a formula filer? Hi AssafHanina , I am using the Filter measure plugin but it does not seem to be doing what I want it to be doing 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. How 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. SolvedRe: How to create a week date range with start and end if the week for each week? Hi Liliia_DevX , Is there a way to do this without a widget edit script? As Compose SDK by Widget ID does not allow widget edit scripts to be render the changes when embedding. How to Display Category with 0 Values in Bar/Line Chart? Hi HamzaJ DRay , Is there a way to display Categories with no data/zero value in a line or bar chart in Sisense without a widget edit script?
GroupsSisense Intelligence Feedback Group This group is dedicated to improving Sisense Intelligence through feedback and collaboration.5 Posts
Sisense Intelligence Feedback Group This group is dedicated to improving Sisense Intelligence through feedback and collaboration.5 Posts