-
Line Graphic with YTD Data (cumulative total each month)
Hi People! I'm here again! We have a dataset in DOMO like this: And we need to create a vision like this: where "LY" is "Last Year" and the "YTD" is the acumulated SALES of the month of the line plus the previous month. Jan = Total SALES of Jan Fev = Total SALES of Fev + Total SALES of Jan Mar = Total SALES of Mar + Total…
-
Share Of Market
Hi, People!! Here i am with more problems... In order to show S.O.M. to my client and knowing that DOMO loses the reference of entire base when the user filter globally, we create lines of totals ($ sold for month, category, etc) that will be used as denominator for % KPI. My problem is: thats a way to select more than one…
-
Increase width in ComboBox component
Hi everyone! There is a way to increase width of ComboBox component to fill all extension of component? We use to show a description field where the length of text is much higher of the width of component
-
Long Execution
Hi people! I'm here again! This time, i have a e long execution problem! I have a table with raw data with 46 million lines, approximately. Here is my first question: When a create a dataflow that process that 46 million rows and generates a output dataset, that dataset is a physical table or anytime i use that output…
-
TOP5
Hey Everyone! I'm here again to use your brains! 😁 Our team is trying to visualize a simple TOP5 of interprise partners considering the total sales of each and we need to see that by month for the past 2 years. We already did this: Beast mode code for ranking: The ranking beast mode is working properly when we use a table…
-
Filtering using BeastMode with a plus
Hi, People! We have a uncommon situation here. We receive a dataset view by Snowflake with raw data and aggregated data and they are distinguished by a filed named "Data Type" 😶 Anyway, We have metrics in beast mode that look to raw data to calculate numerators and others that calculate denominators looking the aggregated…
-
External Chat with DOMO
Hi, People! Anyone already use a external chatbot with DOMO? Our idea is use a external application to ask simple questions like "What's my total sales in Jan/21 of product X?" and that application will log in DOMO, pull the data from dataset or card (is possible to return a card, too) and place the response to the user...…
-
COUNT(DISTINCT *) desconsidering only one filter
Hi, People! I'm here again! The DOMO noob! 😊 I'm stuck with the beastmode problem: Imagine that i have 4 cities e each one of it has a N number of reseller points. In my table, i need to show that N number of reseller points considering all the filters of the page (globals and selections in cards) into one column and in…
-
ALL (as usual in PowerBI)
Hey Everyone! Our team is new in DOMO and we are having some issues with handling Beast Mode formulas as we did in PowerBI. DAX's ALL formula, for example. How do we manage in DOMO to use a denominator that ignores user-selected universe filters, like DAX's ALL does? We tried to use Window Functions, but it keeps…
