Zel Member

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

Ohh, let me try that one and see how it goes, thank you for the suggestion @MichelleH The slicer only shows single value.

@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…

@MichelleH Yes, they are.

Thank you for your help @amehdad ! :)

Hi @GrantSmith does this solution work if I'm using slicer for months instead of the date from dashboard? I tried to uncheck the allow global date, however my card is still affected by the month slicer thing.

Based from the previous image, what I'm trying to look at right now would be an output like this: I will just remove that main category ‘hospital' and use its subcategories instead. Can anyone please help me create using only one card for this? I'm only new with DOMO and still hasn't touched ETL much yet. When I'm entering…

One more question, is there a way to create slicer via beastmode, so I could assign specific category?

Hi @GrantSmith, 2 slicers meaning like 2 separate cards right?

Because the main category (main slicer) - should be hospital, restaurant and store If i select from the main slicer, the corresponding data will be shown. then when I click hospital, there should be an option / sub slicer to select whether it should be Hospital1, Hospital2, or both. (if this is possible)

Hi, @ST_-Superman-_ wow, this is awesome! Thank you so much for this. Will try this in ETL and let you know the feedback asap :D

@MarkSnodgrass yes, that's exactly how I wanted to do it. Oh, so this has to be done via ETL. Do you have any idea how it should look like if it's in Magic ETL? Haven't exactly used it yet, but will try do some research, too.

Hi, @Stuck @MarkSnodgrass. Apparently, something is still lacking in the code, because when I do the code listed below, it's just removing the specific alarm ID with the 'disregard' action, not the alarm ID containing disregard+previous actions. case when `Alarm Description` = 'Lost Connectivity' AND `alarm action` =…

Hi, Stuck. Thank you so much for looking into this. Here's what I needed to do specifically, showing the 3 columns and data below (separating them with comma) <alarm ID> <alarm description> <alarm action> 11111, Lost Connectivity, Pending 11111, Lost Connectivity, Pending 11111, Lost Connectivity, Disregard 11112, Lost…