Zel Member

Thank you very much for your help :D

hi @MichelleH, thank you for this. how about the 2 day and 3 day beast mode? can you also help me with this, too?

Hi @colemenwilson thank you for your inputs and suggestions! 😊 this is all good now.

Hi, @colemenwilson , thank you for the suggestion. Here's what it looks like now: Additional question please, in the first picture in this thread: the red line showing the high limit (100) and green line showing the low limit (32) - they should also be shown in the graph, however when I add them in the card under 'Series',…

Got it, thank you so much!

Hello @GrantSmith , follow up question: What if the slicer that I am using for the scenario above is a beastmode field? Will it still work for all subsets?

Hi @MarkSnodgrass thank you very much for this. Will explore this and let you know if it works. 😊

Hi @MarkSnodgrass thank you very much for this. Will explore this and let you know if it works. 😊

HI, @MarkSnodgrass, If it's not too much to ask, may we ask for your help in creating sample ETL / json file for it? Apologies, we haven't really touched ETL yet. We would greatly appreciate your help on this one so we can also review and see how it goes. Thank you very much.

Hi, @MarkSnodgrass . Apologies, I have some changes with the columns and formulas: Added column: TechNumber (given) UPDATED SORTING: TechNumber - A to Z Alarm Handled Store Time - Oldest to Newest Updated Formula shown below Condition: If TechNumber is the same with previous row, AHT will be computed, AHT: (currentRow -…

Wow! @MichelleH thank you so much, it looks perfect! :D

Hi @MichelleH. It should look like this:

Hi, @MarkSnodgrass, I'm using a grouped bar chart. Is there a way to achieve this?

Hello @MichelleH @RobSomers @ArborRose, thank you so much for all of your inputs. It's working now. I just used the date() function and it worked perfectly!

Hi @ArborRose , when I tried the simple table card, I'm still getting almost same result with what I have on the pivot for the alarm ID. I only need to get the count of unique alarm IDs which is grouped by date. Note: Some alarm IDs have multiple transactions, so I have to use distinct function. Can you help me with this…

Hi @MichelleH, thank you for looking into this. I tried to use Pivot Table and here is the arrangement: [IMG1] Rows: Date Columns: healthcare name Values: COUNT(DISTINCT `Alarm ID`) See [IMG2] for the output If possible, I'd like to retain the dates in the rows like what was shown in excel, since it was particularly…

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

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.

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.