Question Benjamin Bryans · Nov 23, 2016 DeepSee: Filtering a filter When creating a filter located on a dashboard that targets all, is there a way to narrow that filter down?For example, in our data we have some dates that are well out of range due to data quality issues, but they still appear in the drop downs. Is there a way to say, only make available the below dates in the filter?Another example, If we want to only look at Emergency data, it still provides all the wards for inpatient activity and activity in other hospitals, meaning, to get to just the Emergency wards you have to scroll through everything?Hope that makes sense. #InterSystems IRIS BI (DeepSee) #Dashboards 0 4 0 454
Question Benjamin Bryans · Nov 23, 2016 Creating text box widget Hello,Is it possible to create a widget in the DeepSee 2 dashboards that will just contain a block of text?Specifically text that isn't in any database, just free text that can be formatted.Cheers,Ben #Dashboards #InterSystems IRIS BI (DeepSee) 0 1 0 273
Question Benjamin Bryans · Nov 21, 2016 MDX Calculated measure help in DeepSee I currently have an MDX query/calculated measure as per the below: [DaysOnListRange].[H1].[DaysOnListRange].&[Days 91 - 180]+ [DaysOnListRange].[H1].[DaysOnListRange].&[Days 181 - 365]+[DaysOnListRange].[H1].[DaysOnListRange].&[Days 365+]however it currently doesn't sum when there is a blank in the data.How can I amend this query to include empty cells/only sum cells with data?I've tried using nonempty but it doesn't appear to work in this context #InterSystems IRIS BI (DeepSee) #Analyzer #MDX 0 2 0 394