MichelleH Coach

@JenniferGibson , @jaeW_at_Onyx is correct. Currently Redshift and Python are the methods where we've had success with location matching.

@damen Yes, if you click the wrench in the top right corner of the dashboard and select "Save As" you can copy an existing dashboard.

@nathankilcrease What if you added an "Upload Date" column to the dataset, so you can take snapshots of what was in your file at a certain point in time? For example, if you wanted to look at the "version" of the Excel file from October 19, 2022 then you can filter your card so that Update Date is less than or equal to…

@AdamC You should be able to accomplish this with the Rank & Window tile using a Rank function, ordered by EVENTTIME (descending), and partitioned by EQUIPMENT_NUMBER. This will return the most recent event for each piece of equipment with a rank of 1.…

@nathankilcrease If you are using a Doc card, then you will need to manually append the new data to the original Excel file before uploading a new version. However, I would recommend using a table KPI card powered by an appending File Upload dataset instead.

Agreed! I'd also add a couple requests to your idea, specifically for Pivot Table cards: Option to disable subtotals for individual value fields, similar to how it works for fields in Mega Tables Option to disable subtotals for individual row/column fields. Currently subtotals are available for all rows or all columns, but…

This would also be helpful to see as an additional column in the run history so we can compare "Rows Processed" to "Output Rows" at each step.

@bdx I don't believe there is a way to reference the column name in your calculation, though it should be a fairly straightforward (albeit tedious) solution. Since you want to calculate across values in the same row, you can set up either a formula tile or beast mode like this for each new column: `OPP1` + `OPP2` + `OPP3`…

@damen You mentioned that you aren't able to find the older data in analyzer. How are you looking for it in analyzer?

@damen Does your source data still have the correct dates outside of Domo?

@Kellerry That makes sense. In that case, I'd suggest adding is as a new chart type request in the Ideas Exchange

Hi @Kellerry it sounds like you're looking for Domo's Projects and Tasks feature: https://domohelp.domo.com/hc/en-us/sections/360007295954-Projects-and-Tasks

@gsharma Thanks for sharing! I don't see anything that would be preventing you from setting up the alert, so this may be an issue for Domo Support.

Hi @AdamC do you know if you have a fiscal calendar enabled on your instance? If you don't, then Domo's native week groupings consider Week 1 as January 1 through the end of that calendar week. Since January 1, 2022 was a Saturday, Week 1 2022 is comprised of just one day by this logic, which may differ than your company's…

Hi @gsharma could you please share a screenshot of how the card is configured in Analyzer, blocking out any sensitive information?

@gbrown I have had this same issue today and I was not sure if it was isolated to my instance. Have you been in contact with Domo Support about this?

@hanmari You should be able to add an Alter Columns tile to your existing dataflows to change the field from an integer to text. If this field is used in existing joins, then you will need to change the datatype for both sides of the join. I would not anticipate that this would cause a significant impact to existing cards,…

Hi @gsharma since you need some additional logic to look for rows where "Due Date" is in the past, I suggest setting an alert off of a card rather than the dataset. Use this beast mode to count the number of rows where the Due Date is in the past: sum(case when `Due Date` >= CURRENT_DATE() then 1 else 0 end) Add this beast…

Yes, this is much needed! In a perfect world, all card edits would include comments of what's changed, but that doesn't always happen and it's easy to forget. A revert option would be incredibly helpful and less time-consuming.

@SaloniShah Based on your screenshots, those duplicates don't appear to actually exist in your dataset. Try removing the sorting in your card. Sometimes unnecessary sort fields can cause cards to not display correctly.

@damen That's definitely odd! I'm glad it worked!

Hi @damen does it return no rows when you save and run the dataflow, or just when you run a preview? If you haven't done so already, try running the entire dataflow and see if you get different results. Previews do not process every row in order to save processing power, so it is possible that the more recent rows are not…

@damen What returns in your "Current Year, Current Month" beast mode and what are you expecting? Is it possible that there is no data yet, since today is only the fourth day of the month?

@damen In your screenshot where you showed the "Current Year" beast mode, be sure to use the " ` " symbol around your Transaction Date and amount fields, instead of " ' ", so that Domo knows you are referring to columns. It should look like this, when forcing to a number as @GrantSmith suggested: case when…

@Fabien What question are you trying to answer with this card? Based on the number of owners visible in your screenshot, adding an additional series for request type would likely make the card very difficult to read and insights would not be obvious to whoever is looking at it. Have you considered adding Request Type as a…

Hi @Jones01 I'd recommend either of these options: Use a field for first day of week or first day of month in your range selector card Use the dashboard global date picker to filter your dashboard instead

This would be especially useful for scheduling reports off of dashboards since recipients cannot scroll. I often have to leave a significant amount of white space in the dashboard to avoid cutting off the table.

Hi @Jmoreno best practice is to set up a Workbench job on the server to automatically upload Excel files to Domo. You can also install Workbench on your own machine, but that would require it to be running constantly. Are you able to save your Excel file to a network location that your current Workbench application can…

@adeshon Do you have a fiscal calendar enabled in your Domo instance? Your fiscal calendar is in essence the temp table you are describing, which can group and filter your data based on your own company calendar. Here is a KB article with more information:…

I really like this idea. I normally report bugs using support cases, so it's not always clear how many other users in different instances are experiencing the same thing. Having a Dojo section for bug reporting would be great for sharing work-arounds with other users and may be more efficient for support to post updates in…