user32470 Member

Thanks, Grant! You've been more than helpful with me the past 2 days!! I like the inclusion of the Unix Timestamp - learned something new. I found out why it wasn't returning the correct number of days from my first attempt - I was using a pivot table and wasn't aware the function returns the number of days "as-is" without…

The pivot card is set to "ALL TIME" ...It's just showing 10/12/20 because the date range field defaulted to a 3rd date column. It shouldn't affect the beast mode, but I changed the date range field just to double check and its still returning 5 days ...

That makes sense now - so we want to look at the date after not the "day". it adds up now. thanks so much!!

Thanks, Grant! Wasn't aware that Last Day was for month - I used that beast mode for a "Last 12 months" and thought I could just easily modify with "Weeks" ? good to know So I tried out your query (shifted to 13-2) and the value that's being returned is slightly higher than what's being returned via the query. I attached a…

Hi Jae, Thanks for the reply! I should have kept my original post a little more digestible let me re-phrase Question I am trying to answer with my card: * Who are the NEW competitors (just the name - no other metrics) within our vertical that haven't advertised in the last 12 weeks. My "solution": Pivot Table Card *…

Edit - is this feasible via beast mode? For context, it's an uphill battle at my organization to modify the datasets (which I don't have access to)

That make sense! Really appreciate you taking the time to write that out!! 

ohh, I just found a workaround for this. Given the limitation on html markup for the pivot table, I modified my beast mode and then enabled "show negative numbers red" in the chart settings. I'm sure there are many ways to write this beast mode, but the change I made is in the second statement. Now, if there is an overage…

I tried that but what happens is it returns all the code starting with <DIV> in the pivot table. Per the other poster here it might just be a limitation on the pivot table. I'll try it on another type of table for my own learning but ultimately need the pivot table. I'll submit it as a product suggestion to domo. thanks…

Hi Grant I ended up being able to sort it - I took the original day part data the beast mode group was created from (hour of the day) and dragged that into the sorting file as ascending. to answer your question, yes the beast mode does return numerical values when I put in secondary dimension (eg: cost) thanks though!!

Update - I was able to correct the Day of Week to make it sort in order. I made a new beast mode called "Day of Week Transform" where it just contained DAYOFWEEK ('Date') Then I dragged that beast mode into the sort and I was able to sort Day of The Week correctly. The dayparts (hours), I'm still stumped on...