AO3 Member

@GrantSmith is there any way to do this with a beastmode given the dataset structure laid out? Thank you for your help

@GrantSmith definitely thought about ETL work but the dataset is the company's biggest and I don't anticipate being able to make any additions there column-wise. So is there no way to do this with a Beastmode, without amending the dataset?

Well I can't hard code Creative Name values into a beastmode. Then we'd have to update the beast mode whenever a new Creative Name ends up in the dataset. I'm looking to output the unique value(s) in "Creative Name" for a given Week. So filtering down to the Week of 3-4-24, for example, Domo would scan the "Creative Name"…

Here is the attachment

Hi @DataMaven this is a mega table, transposed. I attached a picture here of what I'm looking for as a final result. The problem seems to be that Creative Name is a string field, and can't be aggregated, so it shows as blank. But, within a given "Week Start Date", there is always only one unique value of "Creative Name".…

Thanks everyone for the help. I will go the route of a separate card. Still not sure about how I can do an average? For Totals, I can get the total column easily using that built in function in Analyzer under Properties (Totals > Show Total Row). Even if it has to be a separate card entirely for Averages, there's got to be…

All set, it was a permissions issue after all

@GrantSmith any ideas? Can't seem to get this filter to load

Hi @GrantSmith, thanks for the response. I'm not sure about inspecting network traffic. but I use this field regularly as a filter on other cards (so the same data is being fetched) and it never has a problem. Anything you think it could be on Domo's end?

@GrantSmith is the customized fiscal calendar something that would affect all cards across Domo in our organization? I'm looking for a fix for a single dashboard. Thank you!

Good to know, thank you Mark

So I figured it out I think. You can see in the attached picture I had "Week Start Date" selected as the date field, but when going to analyzer and expanding date drop down, I had it as "Last 12 weeks", but then here was the problem…I had "Graph By" set to "None" Now there is a specific reason I do this. Our company looks…