Zel Member

Hey @DashboardDude . Your workaround is awesome! Thank you so much for your help!

hi @ST_-Superman-_! ETL or card level will do, as long as we could come up with the solution on how to display the average and its format - as mentioned in the original post. The 2 columns look like this: QB-Created Date and QB-Closed Date.

Thank you for your inputs. I'd like to ask, is there a way that I could achieve this in ETL? I have my raw data in Table 1. I want to transform it into something like what I have here in Table 2 thru ETL. I need to have the count of all alarm IDs per store in ETL and rank them accordingly. I tried the above solution but…

Hi @GrantSmith , I tried that just now, but I'm still getting almost similar output.

@pauljames I tried updating the table properties (both with and without subtotal chart properties) but still shows the same output.

Hi @Aditya_Jain how can I get the value from which was selected in the slicer and assign it as a variable control - Project? The thing is, for the initial slicer, I had to do the mapping of the customers/chain and assign them as Project Maya, US, International and Mendel. Then for the variable control, this will be used in…

@MichelleH please see below: If I selected Project Maya, the 2nd column should only count 'disregard' actions. If I selected US, International or Mendel, the 2nd column should only count 'email resolved' actions. Currently, the below image only counts 'email resolved' actions.

@MichelleH reviewing the link that you sent now. Also, just want to clarify, based on the output that I want to achieve (see previous post in this thread), does variable control also work with showing output from columns? Because the 'Action' column from the dataset contains like 20 or more different actions. So based from…

thank you @MichelleH 😊

Hi @MichelleH , apologies, I haven't tried setting up a variable control. Can you please give me an idea how to do it? It will be much appreciated.

Wow! @colemenwilson that was awesome! LOL thank you for that, it perfectly worked!

thank you all for your help :)

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.