MarkSnodgrass Coach

That's a bummer it doesn't show the next level down. To get this to display in a pivot table, you need to ask your CSM to enable window functions in beast modes, if it isn't already enabled. It is not enabled by default. Then you can create this beast mode with this formula to get the percent of total for each month by…

Also, you may want to click on Transpose under General and choose graph by month in the date range filter to get your months as columns if your data isn't already structured for that format.

There are some window functions that can probably do this for you, but pivot tables can be tricky with the window functions. I would start by trying the mega table first. In the chart properties, under subtotal rows, you can enable the option to show percent of total. Then collapsing the items in the mega table, should…

Pretty sure you can't do what you want to do with a pivot table. However, you can customize a flex table to those values calculated. Here's a link to the KB article to show you how to customize it. https://domohelp.domo.com/hc/en-us/articles/360043429073-Flex-Table

@hqu I believe I have come up with a solution for you. It involves creating a MySQL dataflow and creating a function to calculate the next workday and then using the function in your call to your dataset. Here's what to do Create a MySQL dataflow and add in your dataset and the Domo Calendar dataset. Click Add a Transform…

@hqu I would consider adding in the Domo Dimensions calendar dataset into your ETL. It has a list of all dates across a given range and has columns for IsWeekend and IsHoliday, which you could use to help with your counting. If you haven't used it for before, you can find it by going to connectors and search for Domo…

There is this beast mode function that is available, but it requires two dates, so may not suit your needs, but thought it is at least worth pointing out. DATE_WORKING_DIFF(expr1,expr2) Returns the number of days between the dates expr1 and expr2, excluding weekends (Saturdays and Sundays). The result is negative if expr1…

If it is a standalone card, I don't believe there is a way to change the background. If it is part of a dashboard, you can change the background by editing the dashboard and then click on Edit Content for the card and choose change background.

You could use the Rank & Window tile in Magic ETL to rank your entries. Once they are all ranked, you could use a group by tile to get the max value value of the rank and then join it back to your ranked entries and then use a formula tile to determine what percentage it is. Then include/exclude on that percentage value.

You should have the formula tile available to you now that Magic ETL 2.0 is live. You can then do this in a formula tile to remove the $ and convert it to a decimal: CAST(REPLACE(`fieldname`,'$','') as decimal)

You can actually do this in the beast mode and setting your date range filter to group by month of submission date as it sounds like you don't care which month the approval occurred in, just the fact that it was approved. You can get the approvals count by doing a beast mode like this: SUM(CASE WHEN `ApprovalDate` IS NOT…

I find it is easiest to do this in Magic ETL utilizing the Rank & Window tile. Choose the Lag function and then choose order date asc and partition by your account number and order number. This will put the previous order date (when there is one) next to the next order. You can then use the formula tile and the datediff…

I would use the NOT IN condition, which would look like this for you: `domain_2` NOT IN ('url1','url2') Replace url1 and url2 with your actual values. This would exclude these values and include any others.

I have not seen that happen before. In fact, the Magic ETL joins tend to be very exact, including be case-sensitive. I would try making a new ETL and trying to do the join again. Also, to be clear, LEFT JOIN will include all records from the left table and any matching entries from the right table. INNER JOIN will only…

It sounds like you are wanting the card data and not the card definition, which you can get my choosing Send/Export and choosing CSV. To do that via API, I would suggest watching the network traffic using the Inspect option when you click those options on the card and see what APIs they call.

One option is to leverage the zoom capabilities, where you click and drag your mouse around the months you want to zoom into, such as the last two months. You can even start it zoomed in when you are in Analyzer, and then the user can click the arrow to zoom back out. This should keep your running totals in tact. I could…

I have seen some old posts in the Dojo about being able to add [yyyy-mm-dd] as dynamic variable in the file name, but I don't see any documentation for it in the knowledgebase and I can't make that work in my Workbench. Another option to consider would be to use the CLI Tool. This would give you the option to potentially…

Odd. I tested it in my instance with some sample data and it came out looking good.

I would create this for a beast mode and then add this to your sorting: MONTH(`dt`) + (YEAR(dt)/10000) This will make your dates become numbers with decimals where the year is to the right of the decimal place and the month is to the left of the decimal place.

@kofagerburg you might consider using the comparative fill gauge to show this difference. It has the ability to compare the difference between two different fields, which is what you are wanting to do. Here's the KB article for it. https://domohelp.domo.com/hc/en-us/articles/360042924414-Comparative-Fill-Gauge

You could look into using a non-period over period card type and building out your period comparisons using something like this: https://dojo.domo.com/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest You might also consider building up the numbers in an ETL.

To my knowledge, period over period cards don't have that functionality. You could add a quick filter of your list of locations and then the user could select which location they want to view as a way to accomplish what you want to do.

I would suggest looking at the Domo Excel plug-in, which is available under Admin - More - Tool Downloads. You should be able to do it with that. Here's the link to the KB Article. https://domohelp.domo.com/hc/en-us/articles/360043437933-Using-the-Domo-Excel-Plugin

@nshively Understood. I'm sure @GrantSmith will come up with a very elaborate beast mode for you. You can whatever you are potentially slicing by into your group by and rank and window tile and then save the final formula tile work that calculates the average headcount for your beast mode. I have done this multiple times…

I would suggest creating an ETL that groups the data by month/year and sums the employee count and term count. You can then add a rank and window tile and use the lag function to get the total employee count for the previous month as a column right next to the current month. Next, add a formula tile to add your current and…

I agree that this should be an option. In your column label, you can add a \\n to force a new line between words. Not sure that will help you get your text consistently aligned, but thought I would point it out as it is not well documented.

I would create an ETL that splits your data into two using two filter tiles. One filter where userid is null, which is your pre-authenticated data, the other where userid is not null is your authenticated data. You can add a constant tile to create a column called authtentication status. You can then use a join tile to…

What columns are currently in your dataset? I'm having trouble picturing what your data looks like. Do you have one row per month right now? If you can explain a bit more what your data looks like, it will be easier to suggest a solution.

Whenever I am needing to show a goal, I tend to use the Bullet Chart, so I would suggest looking at that for your visualization. https://domohelp.domo.com/hc/en-us/articles/360042924154-Bullet-Chart As for the data, I would start with adding a group by to total your orders by datetime, so that you have one row for each…

If you are using a dataflow, you can click on the settings tab and set the frequency of the refresh rate by choosing On a Schedule and then select the appropriate options. If the card is tied to directly to a dataset that comes from outside of Domo, you can build a basic dataflow that just has an input and output and then…