trafalger Coach

https://community-forums.domo.com/main/discussion/comment/75027#Comment_75027 I know some Bar graphs do, but it's only like "most recent month's value"

Are any actions captured in the activity log?

In this case I'd join to the date dimension, find all of the days between TimeOffDate and ReturnToWork and split the HoursOff between them. Similar to this: https://community-forums.domo.com/main/discussion/50754/etl-magic-join-on-date-range

I'm not sure on this - I'd try reaching out to support and see if they can assist.

Do you need to enable API/Connector access in Clarizen?

What fields do you have? Do you have customer start date and customer end date? You might have to do it in a dataflow, join it to a data dimension and you could calculate for each month whether a customer was active or not.

I think only certain types of cards allow non-summary member alerts, but I've always just used summary numbers for alerts so I'm not positive. I usually just create separate cards just for having summary number based alerts

What kind of data do you have? Do you have customer acquired/customer lost dates? You can join to a date dimension and calculate per customer per month if a customer is active or not.

So you have the right idea with your case statement, but that statement executes on a row by row basis, so it's only comparing the date of the row to the MAX(Date) of each row. Add a MaxDate in the dataflow and then do that comparison there.

Are you looking to have two separate values for Maintenance and Disruption and have them both displayed? Pie charts only support 1 value at a time. If you want to combine them, you can do a beast mode that is SUM(IFNULL(Maintenance, 0) + IFNULL(Disruption, 0)) and then add that to the pie chart.

If I'm understanding correctly, I'd do a group by tile by Site, find the MAX(Latest Updated) and then do an inner join back on Site and MAX(Latest Updated) = LatestUpdated to only get the most recent rows per site.

I've seen this most often if you accidentally aggregate an aggregate, like "SUM(Case when X = Y then SUM(Value))" and then try to filter on that

https://community-forums.domo.com/main/discussion/comment/74803#Comment_74803 DATEDIFF(DATE, LAG(DATE) -1)

use a DateDIFF to calculate the number of days between the dates!

I've seen this before, usually rebooting the server fixes it.

You are too fast @MarkSnodgrass! It accidentally submitted mid-word, haha

Oh I see what you mean. I'm not sure if you can pass date grains via pfilters but I don't think you can

So yup, I'd still recommend the approach in my first comment!

Maybe I'm not understanding your question, but not sure if you need to use rank here, in MySQL I think you would just join on PlacementID and something like "existing date < = DateAdded". To do this in magic you could use a common key (like placementID), join each row to all rows and then filter them out based on dates,…

Here's the Domo knowledge base article: https://domo-support.domo.com/s/article/360042933114?language=en_US, but I'm not sure if you can use dates there. Do you have example code?

I'm not sure either - maybe something with partitions now that dataflows support partitioning?

I'd try putting a space between the two just incase, like ' '. But your logic is sound, that should have worked.

That is a great question, I feel like this might be a grant for a future or roadmap item that hasn't been properly configured.

I don't think so but you could tag them as "Do Not Show" and then filter that out when in you're in the data center

+1 for Domo App Studio! +10 for being in person!

Did you try a different token to see if that fixes it?

You'll have to do this in the dataflow! @GrantSmith and @DashboardDude gave great answers for this problem here! You'll just have to use week instead of month. https://community-forums.domo.com/main/discussion/56964/month-over-month-comparison-on-mega-table-pivot-table

Are you using Domo groups? You could create a Location 1 and Location 2 group, create policies for both of those groups and then put the user in both of those groups.

I don't believe that in scheduled reports that's possible, as like you said, clicking in scheduled reports brings you to Domo. You could send a card with a dataset and include a URL field in your data.

Try using something like this, using the || as an "OR" const where = [ 'ELT_Code = HRES', 'YRMONum = 202305', 'Scenario != Forecast', 'TimeSeriesShort != FY', 'FTE_Position_Type != Actual_Active_Positions' || 'FTE_Position_Type != Another_Exclusion' || 'FTE_Position_Type != Yet_Another_Exclusion'];