WorldWarHulk Member

Thanks Marcel that did it! Also, I used Sum instead of Maximum in the group by tile and I was able to get the results I wanted. and thanks also to everyone who commented and gave inputs.

Hi @marcel_luthi You are correct. it did created multiple repeated entries. I don't know if I am doing something wrong but, I am getting 4million rows compared to the original dataset which only has 255k rows. even after filtering based on 0.

Hi @GrantSmith I was able to join the 2 dataset using the join column, I used the full outer to include all rows from both datasets. I am trying to figure out now what to do with the filter tile. Basically, I want to show everything except those that are within the Wipe Date and Forecast Due Date.

Hi @MarkSnodgrass Thanks for pointing me to the correct direction. Quick question, why is it when I click to connect to our company data, it's just blank?

Hi @amehdad I was able to create a report. The department column are based on the users departments that viewed the cards, is that right?

Hi @amehdad Thank you for your response. I will try this out.

What I did, hopefully it helps others as well >>> the filter is to remove all the nulls and we were able to see who got access to the cards as an individual and who has access to the cards as a group

Hi @ST_-Superman-_ This did it>>> count(count(`Location`)) over (partition by `Name`,`Title`) Thanks!!!

@MichelleH yes I used the formula COUNT(COUNT(`Location`) FIXED (BY `Name`,`Title`))

Hi @MichelleH Thank you for this but I am just getting all 1's ?

Hi @Ashleigh We fixed the SSO names to try the fix but DOMO still reverts the names back...

Hi @Ashleigh yes we have SSO enabled but it is not reverting to what is in the SSO as well. It is reverting to the initial name they were entered in DOMO. we updated 79 names and for some reason there are 12 that keeps on changing back. and doubtful that people is changing them, I am also on the list and I am not reverting…

I am thinking of doing a group by in dataflow where in when they are in Group S then the other groups will be greater than 1. so, anything that is greater than 1 means that they are in a group. if they are not in Group S is 0. but I can't seem to make it work.

Here is an example>>> the New Group S includes Saitama and Flashy Flash We want to exclude Saitama who is in New Group S and those that show Saitama in Group A and Group B and also exclude Flashy Flash who is also in New Group S and Flashy Flash Group A We only want to show Mumen Rider left on the list, since he is not…

Hi @MarkSnodgrass This is it! Thank you so much for this!!!

Hi @MarkSnodgrass so, I tried the beastmode you gave and this is the result>>> I think it is just labeling it. where as with the beastmode I am currently using, I use it to filter and this is what I only get so for Q4 2022, those 8 were counted for that because the `TC: Created Date` is greater than equal to '10/1/2022'…

Hi @MarkSnodgrass Thank you for this. but I dont know how it can capture what needs to be captured before it can determine that it is for that quarter. for example to be determined as "Q3 2019" it needs to be between `TC: Created Date` >= '7/1/2019' and `TC: Created Date` < '10/1/2019' and between `TC: End Date`>=…

Hi @jaeW_at_Onyx I am not sure how to assign the date to my dataset here's what my data looks like>>> I created a date dimension(date) and joined it to my end date column not sure how to show that Friday is for this date and Thursday is for this date based of the Start and End date ranges. for example, in the first row, I…

Hello Nicky - Thank you for this! I have the same problem. As you mentioned, it defaults to 10/1-10/1. sorry for the newbie question, but how can I show the 9/25 - 9/30 again? also Aug 28 to Aug 31 is not being shown as well. basically, I need to show not just the start of the month but also the end of the month, 8/28 -…

Thanks Grant! although, I am wondering why I am getting a 10/1/2022 - 10/1/2022 and not getting the 9/25/2022 - 9/30/2022 instead?

Thanks for the quick help!!!

Hi Rob - Thanks for this!!!

Thanks Rob! I will try adding it to my current beastmode!

Yes. everything is successful when I deepdive on the status button.

Yes. it shows as successful. also, when I click preview, there is data in there. but after I click, save and run. it shows that the 2nd output dataset as "unable to load this dataset"

Hi GrantSmith Thank you for this. But its weird because, it works for some and not for others? and its also not consistently capturing the second name of the ones that have second names. Thanks

Thanks GrantSmith! That did it!!!

Hi GrantSmith basically, the object name has the card info and the page info. I tried creating a beastmode to pull the card out of the object name. I put the beastmode inside the drill path in the analyzers visualization, it looks like it works, but when I go out and try it, it still doesnt give the most viewed card of the…

Hi GrantSmith Got it. so I need to create an Objectname for Page and Objectname for Card. I will try that.

Hi Grant Thank you for all your help. I connected the Beastmode dataset to another dataset to get the owner name. and I added the owner name to the groupby18. new question is, why am I seeing duplicates that are not grouped together? they have the same formula, dataset name, beastmode name, and beastmode formula. but is…