-
Filters on Multiple Pie Charts
I have the following on a dashboard: I want the user to be able to filter the left and right charts using the slicer for different time periods, without resetting one when the other is used. Meaning, I want the left chart to show me FM6 and the right to show FM7. Any ides how I can go about this? The charts are already…
-
How can I get additional Groups in this Pivot Table?
I'm trying to produce a table similar to this one in DOMO so I can get it out of Excel: I am currently using a pivot table and have everything working EXCEPT the 'Forecast', 'Actual' and 'Actual v. Forecast' groupings. The data is a combination of actual fields and beast mode calculations. Any ideas on how I can do this in…
-
How do I get color rules to apply to all pivot table levels?
I want to apply color rules to a pivot table that shows weekly, monthly and quarterly results. I can set the rules to the weekly level, but they are not applying to the monthly or quarterly roll-ups: You can see above that the %Diff Column is showing the colors, but the '1 Total' columns on the far right do not. Any…
-
Sorting Items in a Checkbox Selector filter
I have a Checkbox Selector filter that has fiscal weeks for a client to choose from. It currently looks like this: How can I get the weeks to appear in order left-to-right instead of vertically?
-
How do you set a table to automatically go back 2 fiscal weeks for a report?
I have a client with a custom fiscal calendar. I have a report that automatically returns data from the previous fiscal week (Sunday to Saturday). I need a second report that will return the same data from two fiscal weeks ago. Does anyone know how I can automatically have the fiscal week updated for this report?
-
Can I run a Stored Procedure to an external MS SQL and import resulting dataset?
I have large amounts of data stored in an external MS SQL database. Complicated queries are run via a stored procedure, and the resulting dataset is written to a table that I currently have connected to DOMO to produce client dashboards. I'd like to call the stored procedure from the DOMO data connection, have it run,…
