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…

Hi Grant - Good Day! Yes. they were somewhere in the middle when I scrolled down. I was able to create a card. and here's what I got>>> with the count, I am assuming that is the number of duplicates is that correct? Thanks!

Hi Grant what do I need to input in number 2 in groupby? I can't connect the remove duplicates, it says connect to a valid source. also, when I try to paste your formula, here is what happens also, quick question, when we use remove duplicates? wont it remove the duplicates? remember, we need to show/identify the beastmode…

I believe, I now have the correct dataset. in the ETL, is this correct?

thank you for all the info GrantSmith. This is very much appreciated. in the DOMO Governance dataset, these are the only columns I am getting: ID Name Link Owner_User_ID Created_Date Last_Run_Date Status Schedule Import_Type Data_Provider Source_Type Cards_Powered PDP Enabled Shared Account_ID does this mean, our DOMO…

I can't seem to find the Domo Governance Third Part Connector... can you point me to the right direction? I am able to find Domo Governance Datasets, but I doubt that that is it...

Hi GrantSmith Where did you get the beastmode formula and cards? basically, how were you able to create your beastmode dataset? I am only using the DOMO activity log and then connected it to datasets and dataflow...

Hi Grant thank you for the suggestions. but the problem I have is that, instead of 1 reference date, I have 2, the created date and the end date. wherein the created date should be for the current quarter AND the end date should be previous quarter.

unfortunately, the laptop is dead and I can't export it anymore. I do have the files I used. 

subscribed to your youtube channel Onyx Reporting

you mean to say, it will lose any data when the new data is appended? I need a data to be appended and create a snapshot of historical data... my data comes from salesforce which doesnt store historical data... 

yes. or can I use the batch date for that?

there aren't. I tried removing the trim function but nothing changed.

This looks like it did it!!! or close to it. what I am seeing now is the totals on some of the months are off by one or two.. and deep diving, the missing names are unique names... 

vecause there can be multiple test taker per same account. meaning there can be same account number but different names for example 1/1/2019 12345 WorldbreakerHulk 1/23/2019 12345 Superman 1/29/2019 12345 Superman 1/30/2019 12345 Superman the total for january would be 2 they are all with the same account number. if we use…

unfortunately, right now, the count distinct is showing duplicates and counting them as distinct.

if a name already appeared in a previous month, it shouldn't be counted for the following months. the name should only appear on the month that they first appeared in. unfortunately, it is not happening right now using the count distinct function in beastmode. is there a way maybe in magic etl?

yes. but those duplicate names shouldnt be counted anymore. per row, we will have different dates but we can have the same names. is there a way for domo to think that even though its different dates, since its the same name its a duplicate? 

also, when I did the MIN in the corrected date in a table, It showed far less data now... a lot less...

it needs to be in a bar graph.. I just showed the table to show the duplicates being counted as distinct.

here you go. for the screenshot on data 4... basically we have 4 records there based on the resource name, and the 5th one is a duplicate.

here you go

here you go

I changed the aggregate on the date column to MIN and the duplicates got worse.

I am not sorting it with anything.