How to Summarize PCPs and there admission by using heatmap or anyother like pivoted table Accordingly

Question & Answer
, , , ,
1

Prepare heatmap kind of report to summarise PCPs based on following criteria:

  • Admission Percentile <= 50 : Green
  • Admission Percentile >= 50 and PCP Visits Percentile > 50 : Light Green
  • PCP Visits Percentile <50 and Admission Percentile between 51 and 75 : Grey
  • PCP Visits Percentile <50 and Admission Percentile between 76 and 90 : Yellow
  • PCP Visits Percentile < 50 and Admission Percentile > 90 : Red

For each block, when clicked should show the list of PCPs with detail cost and utilisation information.

2

I don’t think you can combine two different metrics on a heat map. Although you can do three colors.

image
image1136Ă—706 59.3 KB

For pivot tables you can have multiple conditions and do it across the whole row / just one column.

image
image1119Ă—722 75.9 KB

In regards to the blocks you can add actions that filter other visuals / drill down.

image
image1092Ă—602 60 KB

1 Like
3

@Sushma1 Did Max’s Solution help? I am marking his reply as “Solution” but feel free to uncheck it and let us know if you have any more questions or need anything else to get to a solution.

4

I am sorry to say Max’s Solution did not help me. Although it might help others who are looking for different techniques .