-
Pivot Table - Use of Beast mode in the rows
Sharing the feedback on behalf of the customer from Learn IT Systems, he suggests that the Pivot table card should allow the use the of Beast modes having Windows function/ Aggregation in the rows section of the card. Presently it does lead to errors in Subtotal/Total while using such beast modes.
-
Is there a way to bucket columns similar to excel in DOMO?
I am trying to have a pivot table that shows weekly plans vs actuals. Is there a way to add a top layer of that to group the value columns into the top three pillars? Supply, demand, revenue. Thanks
-
Single Value Card Division
I have two single value cards. Card 1 is a overall total of all possible values and card 2 is a filtered subset of card 1. Is there a way I can divide the two cards? I know that you can just make a new beast mode with both calculations (Ex. Card 2/Card 1). However that does not work in my case due to Card 2 being a…
-
How to filter cards by a name dimension
A user recently ran into trouble while creating a dashboard. According to them, the dashboard had about 10 cards in it. One card was powered from one dataset, another card was powered from another dataset, and then 8 cards were powered from a third dataset. Their question: Is there a way to filter all cards by a name…
-
Customize Color Theme / Reverse Order
I recently built a heatmap table where I want the lowest numbers up top. These start around -25 and end at -10 currently, but the numbers will change each time the chart is updated. I also only want to show 10 rows of data, so the table has been limited to the 10 top results. I want the heatmap to display negative numbers…
-
Is Domo treating 0 as NULL? Card filtering 0 value as NULL
Hi everyone, is this a legitimate expected functionality or a bug? In my card, I have a filter on NPS Score IS NOT NULL. However, it seems to be filtering out my records/rows with NPS Score = 0. Is Domo treating 0 as NULL?
-
Grand Total summing the percentage instead of calculating
Every time we bring in any kind of calculated difference to the table, we get a grand total that sums up all the percentages. For instance, for this Table, the rightmost column is calculating the difference between the two left columns. Every row is correct except for the Grand Total which sums up the percentage together…
-
Lag Function Giving me Values that Don't Exist?
I'm trying to create what should be a simple table that shows job Last Quarter Salary, This Quarter Salary, and Percent Change. However, my Beast Mode is giving me values that aren't even on my table. The Current Salary is displaying fine, but the previous quarter's salary is giving me a fictional number. Here's my formula…
-
Filtering on multiple datasets / changing default dataset
Hi, I have a dashboard with multiple cards. Each of these cards pull from different datasets, however they share many common fields. This is helpful when using global filters. When adding a filter, I select the relevant field, and then select all datasets so all the cards will be affected by this filter. However, then when…