Astroraf
Data Integration
Joined 2 years ago
User Profile
User Widgets
Contributions
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.6Views0likes1CommentHow 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.How to create a week date range with start and end if the week for each week?
Hi DRay Liliia_DevX , I am looking to create a week range for a line/column/bar chart where lets say it is the 30th week of 2024, then the 31st, 2024 and I want the 30th and 31 st week to shows Sep 24 - Sep 31 2024, etc. Is there a way to achieve this within the model or in the back end of a live data model.
Groups
Sisense Intelligence Feedback Group
This group is dedicated to improving Sisense Intelligence through feedback and collaboration.5 Posts