When I add the "Total Row" to a pivot table, it does not always show the "Grand Total". If the column has an aggregation applied, then the Grand Total shows the aggregation (Average, Maximum, Minimum, etc.) instead of a Total. Is there a way to show the actual "Grand Total" (aka the sum of the values) rather than the…
I'm trying to set up a beast mode formula to calculate YTD Asset Yield. It doesn't seem to work because of the Month function. I also try to create a formula for Month(`Monthend Date`) within the ETL, and that did not work too. Do you know if there is a reason why this does not work and do you have any suggestion to make…
Hi, I need the day across the top of this table and the visits/ orders etc along the rows, how can I transpose this table ? any help appreciated!
Typically when I edit a card within a dashboard, I've first used the wrench to select "edit dashboard". Then, when I hover over a card, it displays "edit content" and I use that utility to edit the card. However, on one of the dashboards that I inherited, the card only displays "remove" when I hover over in the same…
I am wanting to add checkboxes to each line in a table so that I can select the check box to signify that line has been completed as I am working through the list, is this possible? Next part to the question would be is there a way to make sure the boxes that get checked stay checked after I go back to the home dashboard…
Hey Community, I have a head-scratcher. We are experiencing an issue with our Month to Date (MTD) calculation in our Daily Snapshot reports. Throughout the month, the MTD calculation works as expected, showing the cumulative revenue for the current month. However, on the last day of the month, the calculation does not roll…
I have a column labelled "Key". I am wanting to do a group count of these as otherwise I have too many rows (in table format). The first four numbers represent a project, I am currently doing a COUNT of these, and it comes back as 1 for each as the number is unique due to the numbers after the -. Is there a way to do a…
Hi I want to create a table where user can select the date comparisons between two periods. Just want them to pick the date comparison and the data reflect in the tables accordingly. And how to create another dimension with %chg based on two periods. For ex. User wants to see total GMV between Sept 1st to Sept 5th for 2024…
We found the Card Fields & Beast Modes Governance dataset which shows what fields are being used in cards and beast modes but we would like to track a field name from it's original dataset > name change (if it applies) > DOMO asset.
Hi there, I have a dashboard for reporting on the results of my A/B tests. You select what experiment you want to look at from the filters, and the KPIs are populated for each variant, as well as a Lift/Decline for different metrics which is calculated through different Beast Mode Calculated Metrics. My question is, is it…
It looks like you're new here. Sign in or register to get started.