MichelleH Coach

@louiswatson I would recommend a couple things to fix this: Under the General Chart Properties, check the box next to "Auto Zoom to Data". If all your points are within the UK, then it should frame your map to a smaller area Use the same value for all the points so they are the same size. You can do this by creating a…

Hi @louiswatson I do not see any issue with the Lat/Long format. What settings and chart type are you using?

@user084115 I also recommend changing your date format to '2022-01-07'

@karan No, this is not currently an option. I suggest submitting this as an idea.

Hi @hmicm yes, there is a "Drill In Place" option on the card Interaction settings. You can access this via "Edit Dashboard" - "Edit Content" - "Change Interaction"

Hi @user084115 try removing the comma after UPDATE "table1"

@louiswatson Can you please share an example of the lat/long format that you are currently using?

I agree with everything that's been said already about editing column names in the ETL. An added benefit of renaming at the ETL step is that it makes it easier to set up page filters, since they rely on the name of the field. This is especially useful if you are using multiple datasets on the same dashboard.

@ozarkram Try changing your beast modes on the Y axis and series so the case statements are within the aggregate. For example UNITS ON ORDER LY ORD DATE should look like this : COUNT(CASE WHEN `FISCAL_YEAR` = `CUR_FISCAL_YEAR`-1 THEN `units` END)

@ozarkram What chart type are you using? That my also make a difference

@ozarkram Do you have any sort of aggregation applied to your sort field? If not, try sorting by AVG of Week Number

@Steve-DOMOnoob Can you please share an anonymized data sample?

@Steve-DOMOnoob What specifically are you trying to rank? R-Squared is just a single value for a regression model.

@slesty If you want to see the the totals by shipment, then I recommend creating a separate output to your ETL to remove all customer-related fields and remove duplicates so have a single row per shipment. Then you would use that output for cards to aggregate the invoice amounts without double-counting, and use your…

@jordan_platinum An ETL update is likely your best bet in this case. I recommend using the ETL Rank & Window tile to add a count of non-null Procedures, partitioned by Appointment Number. This will tell you how many procedures are scheduled for that appointment. Then you can filter the drill view of your card to only show…

@slesty To be sure I completely understand your question, what are you expecting the Ship Invoice total to be in your double counting example? Should it be $10 for Customer A and $10 for Customer D?

@Recluz Yes, completely agree!

@user069416 Were you ever able to figure this out? There are users in our instance experiencing a similar issue, so I am trying to determine whether I need to reach out to support.

Thanks @GrantSmith, that's what I suspected but wanted to make sure.

If your content divided into multiple cards, then try arranging them in separate layouts since Domo will not set page breaks in the middle of an existing layout. You can add a new layout from the "Edit Dashboard" screen by clicking the "Layout" icon on the right side of the page and dragging it to the spot where you want…

Agreed! The problem I run into when I click the "Edit ETL" button is that once I save or cancel after viewing the dataflow edit screen, it redirects to the Data Center rather than the dataflow Overview or History screen so that I have to go looking for it again.

@Pedro_Valverde Do you have any other fields sorted?

Yes! It would also be great to see who already has access to a dataflow, similar to the dataset "Overview" tab.

Hi @Hiraayub when you say you want a the average volume by hour, do you mean the average cases within, say hour 1 and hour 2, across multiple days? If so, try changing your beast mode to partition by day instead of by hour, since your data is already separated by hour in the x-axis. COUNT(`Case Number`) OVER (PARTITION BY…

Hi @JunkDoom yes, Domo has a relatively new feature called DataSet Views that allows simple joins and transformations. You can read more about it here: https://domohelp.domo.com/hc/en-us/articles/360046074774-DataSet-Views

Hi @svetlana you can add back the columns you want by selecting "Add Columns" in the group by tile in ETL. Alternatively, you should be able to do all this in a card without an ETL. All you need to do is create a card that includes your snapshot date graphed by month and a count of employee name/id. That way it's more…

@MattGo I'm not sure if this helps your situation or not, but hyperlinks do work in scheduled reports if they are in the summary number.

Hi @keeeirs10 are you saying that the Dummy column is only populating "Remove" in some rows, but not all? That's likely because your updated query (the second one you posted) removed the "WHERE Dummy is NULL". If you only want to output rows that are included in lever_inactive_report then I would change your join from a…

Hi @leeloo_dallas are you trying to show all data from the past 24 hours, or a summary of your metric across multiple days? If it is just the past 24 hours, you do not have to extract the time from your datetime column. You can just set the timestamp as your x-axis, then set the date range to "Previous 24 Hours" with Graph…

If you click the gear icon on any of your quick filter fields in Analyzer, you can change it from Multi select to Single select.