Godiepi Coach

It would be great if we could format each column to export, sometimes clients ask for reports to be sent out in certain format. we are trying to put them in Domo so that our clients can export them anytime, but the export cannot be formatted. Could it be added as an Idea ? Thanks

you need to bring a date field into the sort option box and select ascending order. now, if you have a day of the week field as text that shows Monday, Tuesday, Wednesday etc what you can do is to create a beastmode and use it for the sort option the beastmode would be like this: Case When `YourTextField` = 'Monday' Then 1…

Yes , that is correct. it is very useful when using different type of metrics in one single chart (percentage vs volume). it depends of what you are trying to show, so in the case all your series are percentages you can either set the number of lines as such or just use a muti-line type of chart instead.

SELECT * FROM t1 LEFT JOIN t2 ON t1.id = t2.id UNION ALL SELECT * FROM t1 RIGHT JOIN t2 ON t1.id = t2.id

That is easy to fix. Just keep in mind when draging the calculations into the series position, to do it in cretain order. for example : you have 3 series , 2 of which are percentages (one is your goal cal) and the third series is counts. from left to right put the series that are percentages first and then the other series…

Hi Dale , please see the image attached. hope it helps.

Try this beastmode and use it as your x-axis CASE WHEN WEEK(`TransactionDate`, 11) = 1 THEN STR_TO_DATE(CONCAT('12-31-', YEAR(`TransactionDate`) - 1), '%m-%d-%Y') ELSE `TransactionDate` END

It depends what you have on your X-axis , usually a Date field, so lets use "Date" on this example. Lets said you want to show always Yesterday (Bar in Green) and the rest of days (Bars in Blue) you can do that creating a beastmode that will become your series. BeastMode: Test case when `Date` = DATE_ADD(CURRENT_DATE() ,…

Yes , I think that you added the code I gave you to your count beastmode. add it as a filter and that will force the chart to display only weekdays and hide the weekends. but since the date is present in your data the chart might still make it show up. have you tried created a data flow that only includes weekdays ? that…

Base on the screenshot it is working , bars are showing zeros for September 3 , 4 , 10 , 11 etc which are Saturdays and Sundays. so, it is not including weekends for the counts. now, to make a date display as name of days , that would need to be created as a different beastmode.

Yes , you can do it through a beastmode. CASE WHEN DAYNAME(`TransactionDate`) IN ('Saturday', 'Sunday') THEN 'NO' ELSE 'YES' END Then you can add this as a filter and it will get rid off the Saturdays and Sundays

Yes, you can do it this way 1) build the card as you normaly do 2)under chart properties > general , check the boxes a) Sync Value Scales b) Hide Second Scale c) and just to be in the safe side the box for Sync Zero Line that should do it.

Hi , I suggest asking Domo support to make a 'Calendar' dataset available for you (this if you dont have it already present as a Domo Dimensions Dataset. then you can create a dataflow doing a full outer join between your data and the 'Calendar' data. that way since your data does not have some dates present, the calendar…

Hi @adirenuka sorry for the late response. I was not able to see the card on your link. it asks for credentials. (you could upload an screenshot if you still need it) so, coming back to what you like to display, I believe that a pie is not the best chart because it does not allow you to display different types of data…

I don't think that it is possible. if you want to give more detail , have you tried creating a "Drill Path" card ? example, a slice of the pie shows 45%, then the user clicks on it and it opens a new card that shows the dollars and count of records in a Bar card of any other type of card.

let see an editor user sees a card in a particular page showing x metric by month, then decide to duplicate the card to its overview page and modify the card to show the same metric by week. then starts a conversation making reference to the duplicated card without tagging it in Buzz. at times could be confusing for other…

It would be great if 1) there was a section designated to manage all beastmodes. 2) a way to make the functions such as date/time functions to operate based on the admin selection of eastern time or so. 3) a way to tell Domo date grain in cards and also functions in beastmode that our week starts on sundays or mondays. 4)…

Gosh ? i'm running out of ideas. is the column generated from a formula in the excel ? last thing to do is to create a data flow in Domo , magic etl , bring the input dataset and from the edit column menu use the set column type option to force the column to display as number instead of text in Domo.

Can you run a formula on your excel for that column ... =ISNUMBER(yourcolumncell) and drag it down til the last record, see if any returns false

if you can , go into the excel and make sure that all values in the columns showing amounts has nothing other than numeric values... what happends is that usually the excel is updated by a person and if someone enters a text value by error in one cell , it makes the whole column a text column. it could be a comma , a space…

where does the data originates from before making it into Domo ? from a sql view uploading through wrokbench ? from an excel spreadsheet store in your machine or in box or other uploading it into Domo using a connector ? etc

bring a date column to the sorting box on the left of your chart and select ascending order

if your results are always in Billions then you need to divide each calculation by 1 Billion. it might give you something like this 1.22222222 (maybe not) , in that case you have to round the results to 2 decimals. if not always is in billions then you'll have to play with some case statements , case when result greater…

if your results are always in Billions you'll need to divide every result (individually) by 1 Billion. doing that might give you a funny number like this 1.222222222222222 ? (maybe not) , if that happens you have to round that result to 2 decimals. if the results are not always in Billions then you will have to add more…

Yes you can do that , look at this for example. you will need to create a beastmode concatenating everything you what to display and select the check box 'apply to summary number. this is the structure of the formula for the summary number . I have hiden stuff I can't share.

Hi Emilio Look at your left in edit mode , the chart properties box and make sure under "general" to select , divided by 'None' .... by default is diving by thousands , thats why your results show 4K

Typical of Stakeholders ?

It is not possible in Domo yet. what's wrong with the Triangle ?

Make sure to add the beastmode as a Filter so that the last Date does not show up at all

You can create a beastmode to be added as a filter that reads CASE WHEN `YourDate` = CURRENT_DATE() then 'No' ELSE 'Yes' END