How to get values from a different card?

Zel

Hello, I want to create a donut chart containing two values (both coming from different cards).

Say for example below, I have these 2 separate cards (Single Value) [see IMG1]. The values of these 2 cards vary depending on which was selected in the slicer filter.

Is there a way I could create 1 card (donut) showing these 2 values in a single chart? [see IMG2]

============================

[IMG1]

[IMG2] sample only, image from excel

MichelleH

@Zel Since your calculation for Remaining Balance requires subtracting the Total Alerts/Events Used, I would actually recommend using a Filled Gauge card instead of a Donut/Pie chart. In this case you would use COUNT(DISTINCT Alarm ID) for the gauge values and the total amount of credits as your Optional Max Value.

Also, does your slicer allow you to select multiple values for Store Chain? If so you may want to reconsider using a SUM(DISTINCT ) function. For example, if you filter to "Common Spirit Health" and "VA Medical Center - Forth Harrison, MT" should the total amount of credits be 200? The way your Remaining Balance calculation is set up now it would only return 100 since they both have the same value.

MichelleH

@Zel Are both cards on the same dataset?

Zel

@MichelleH Yes, they are.

MichelleH

@Zel Since these cards are on the same dataset, I'd recommend creating a beast mode that mirrors the logic of each card and segments your data between "Total Alerts/Events Used" and "Remaining Balance" to use as the series of the donut card. Depending on how your original cards are set up you may need to create a second beast mode for the values as well.

If you need some additional direction on the beast mode(s) we would need to see how your original cards are set up.

Zel

@MichelleH here it is:

For "Total Alerts/Events Used"

• COUNT(DISTINCT Alarm ID)

For "Remaining Balance"

(SUM(DISTINCT CASE

when Store Chain like '%Penn Medicine%' then 250
when Store Chain like '%Utah Public Health Lab%' then 200
when Store Chain like '%VA Medical Center - Philadelphia, PA%' then 3719
when Store Chain like '%VA Medical Center - Wilmington, DE%' then 1000
when Store Chain like '%William Beaumont Hospital - Royal Oak Campus%' then 200
when Store Chain like '%Common Spirit Health%' then 100
when Store Chain like '%VA Medical Center - Fort Harrison, MT%' then 100
when Store Chain like '%HCA Management - Master Parent Account%' AND Store like '%TRH%' then 1
when Store Chain like '%HCA Management - Master Parent Account%' AND Store like '%LPH%' then 200

ELSE 0
END) )

- COUNT(DISTINCT Alarm ID)

=================================================

For the "Remaining Balance" case when statement - there's a slicer for that, whichever is selected, the corresponding number will be used and deduct the count of unique alarm IDs (Total Alerts/Events Used).

MichelleH

@Zel Since your calculation for Remaining Balance requires subtracting the Total Alerts/Events Used, I would actually recommend using a Filled Gauge card instead of a Donut/Pie chart. In this case you would use COUNT(DISTINCT Alarm ID) for the gauge values and the total amount of credits as your Optional Max Value.

Also, does your slicer allow you to select multiple values for Store Chain? If so you may want to reconsider using a SUM(DISTINCT ) function. For example, if you filter to "Common Spirit Health" and "VA Medical Center - Forth Harrison, MT" should the total amount of credits be 200? The way your Remaining Balance calculation is set up now it would only return 100 since they both have the same value.

Zel

Ohh, let me try that one and see how it goes, thank you for the suggestion @MichelleH

The slicer only shows single value.

Zel

Hi @MichelleH , is there a way to show correct % instead of the actual value?

[IMG1] shows the actual value

[IMG2] shows the result when I changed the format to percentage

MichelleH

@Zel Yes, to show percentage you would update your value field to divide the count(distinct Alert ID) by the case statement currently in your max value field. Then you would set your max to 1 (100%).

Zel

Great, thanks for your help @MichelleH ! But in Filled Gauge card, there isn't any option to show alternate values, such as the value itself and %, right?

Like for example, the main display would be the percentage and when you hover, it would show the actual value, just like on other card settings.

MichelleH

@Zel I believe that is the case. If you already have your two original cards showing the values, then I would suggest using just the percentage in the filled gauge card

Zel

Thank you again, @MichelleH ! 😊 Appreciate your help!