Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to only show records that have a percent value over 5% and then show the top 10 sorted by total. I have tried using dimension limits and it doesn't give the the result I am expecting. I have attached the application and you will notice the chart is showing the top 10 by total, but there are records that have less than 5% showing. I would like this chart sorted by Total and only shows the 10 where the % is greater than 5%. Any help would be greatly appreciated. Thank you
You may want to take down that example and scramble the PHI. I believe MRN counts as PHI under HIPAA.
To solve the issue you could use the Show Values 'Greater Than' 5% relative to total. But this would show over 10 categories if there are over ten values that are greater than 5% of the total. In your example there are not.
Use expression as below
IF(COUNT(DISTINCT
{<
FLG_POSTED_CHARGES_WITHIN_4_DAYS = {0},
DateType = {'TX_POST_DATE'},
TX_POST_DATE = P(DATE),
FLG_OSU_COST_CENTER = {0}
>}TX_ID)
/
COUNT(DISTINCT{<
DateType = {'TX_POST_DATE'},
TX_POST_DATE=P(DATE),
FLG_OSU_COST_CENTER = {0}
>}
TX_ID) >= 0.1,
COUNT(DISTINCT
{<
FLG_POSTED_CHARGES_WITHIN_4_DAYS = {0},
DateType = {'TX_POST_DATE'},
TX_POST_DATE = P(DATE),
FLG_OSU_COST_CENTER = {0}
>}TX_ID))
and
IF(COUNT(DISTINCT
{<
FLG_POSTED_CHARGES_WITHIN_4_DAYS = {0},
DateType = {'TX_POST_DATE'},
TX_POST_DATE = P(DATE),
FLG_OSU_COST_CENTER = {0}
>}TX_ID)
/
COUNT(DISTINCT{<
DateType = {'TX_POST_DATE'},
TX_POST_DATE=P(DATE),
FLG_OSU_COST_CENTER = {0}
>}
TX_ID)>=0.1, COUNT(DISTINCT
{<
FLG_POSTED_CHARGES_WITHIN_4_DAYS = {0},
DateType = {'TX_POST_DATE'},
TX_POST_DATE = P(DATE),
FLG_OSU_COST_CENTER = {0}
>}TX_ID)
/
COUNT(DISTINCT{<
DateType = {'TX_POST_DATE'},
TX_POST_DATE=P(DATE),
FLG_OSU_COST_CENTER = {0}
>}
TX_ID))
Thanks for noticing the MRN. I thought I scrambled all the PHI. I have taken that down and uploaded one with MRN scrambled.
Charles I tried this and when I change to use the Show Values 'Greater Than' 5% relative to total, cost centers with less than 5% still show up.
Manish,
This is not working. Giving me -%'s for most of the numbers
Hi Tom,
I think you can do something like
if(percentage > .05,
expression)
in both your total and percentage expressions that should work.
-Ray