Astroraf
Data Pipeline
Joined 2 years ago
User Profile
User Widgets
Contributions
How to filter a table/pivot table: Filter one column that does not equal another column?
Hi DRay Liliia_DevX , I am trying to see if there is logic where I have a pivot table and I want to filter one column based on another column that do not equal, so getting all the results that match within a widget filter or maybe a formula filter.CASE WHEN logic in Formulas
Hi DRay , I am trying to use the CASE WHEN logic in the formulas but does not seem to work. My logic: SUM(IF([Total DEFINITIVE_EST_NUM_OF_ER_VISITS]>0, [Total DEFINITIVE_EST_NUM_OF_ER_VISITS], 0)) but this does not give a value of 0 when I am looking in a tooltip map, it stills shows N/A in the tooltip. I tried a CASE WHEN Statement: CASE ( WHEN [Total DEFINITIVE_EST_NUM_OF_ER_VISITS]> 0 THEN [Total DEFINITIVE_EST_NUM_OF_ER_VISITS] ELSE 0 END) But I get unexpected token, and from the documentation I am doing everything correctly. The goal is for the tooltip information for Hospitals with ER visits that have 0 visits to show up as 0 rather than N/A in the tooltip information.
