Zel Member

This is my Join Tile settings. I have my column Count of ID from Group By, just like what was mentioned above, but the counting output is incorrect. The Split Column - shows the new Global Device ID, since I have to omit characters with hyphen.

Hi @GrantSmith . When you said here "then join that back to your original dataset based on the loan_id". Will you show us how to do the join part thing? Apologies. I'm trying to replicate this solution, but I'm getting a hard time doing the Join part. 😅 Not sure what to put there. Thank you in advance.

Hi @GrantSmith. I already tried using "not equal" in my ETL, but still showing the same output.

@DavidChurchman I think that make sense. 😀 I will try your suggestion with my ETL now. Thank you for your idea! I will let you know if it works.

following up on this thread please, thank you. hope someone can help me.

Hello @ColemenWilson and @DavidChurchman. Thank you all for looking into this. For context, I have separate dashboard cards using the original dataset (Tracker_Snowflake_Dataset) for Cards 1 and 2 showing the filters below. Then I have to come up with Card 3, combining data for both Cards 1 and 2, following the steps I…

I think ETL is a better option for this, it's just that I think I'm missing something or I'm using wrong "Join Data" option not sure what to choose (inner, left, right, full) Create Filters for card 1 Create filters for card 2 Join data - card 1 and 2 trim / remove excess characters from -XXXXX (how can I do this, too?) I…

Hi @ColemenWilson, I think it's a bit more complicated than that. The thing is, I need to combine the output for cards 1 and 2 first. Then I have to remove duplicate IDs from there and apply the filter: Company Name does not contain 'MR'

@MichelleH thank you so much! 😊

@MichelleH How can I contact Domo support? I have 2 cards similar to this top level card and the drill-down data are working fine. It's just for this specific card I'm getting an issue.

@MichelleH Yes, 10 rows (from top level card). No "Limit Rows" for the drill down card. Results shown above are from data limited to 10 rows (from top level card). I tried removing "10 rows" from the top level card and just showed "all rows", and I'm no longer getting anything from the drill down card, even from the Data…

@MichelleH Not showing anything as well. Same output as above.

thank you all for your help 😊

@MichelleH I tried doing that and I'm getting the result below. Apologies for the questions. Please bear with me 😅 I really appreciate your efforts. and these are 2 beast modes: string format and date format

@MichelleH I see. Thank you for letting me know. Is there a workaround for this view? Just like what we have in the previous snapshots.

I see. Thank you for letting me know. Is there a workaround for this view? Just like what we have in the previous snapshots.

@MichelleH thank you for the quick response. I tried using the beast mode but still getting the same dates at the bottom.

Hi, @david_cunningham and @MichelleH , thank you for looking into this. I will be using it for 2 cards. I tried the beast mode you sent, but getting an error. 🙁

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 :)