-
Pivot Tables
Pivot tabels views are not very clean and clear, any workarounds and tip to it ? Also, if anyone can help how can I set my view like this in Pivit, I am using Fiscal Calendar. Quarter by month
-
Stack Bar
What shall be my settings to write the hover text in this gragh. I want the o.p to be dispalyed as this, Also when I want the data to be displayed in Months, like weeks 1-5 shall formulate as January.
-
Rank & Window Function
I wanted to create two static fields for two different tabels coming from WB. 1.One is ID- unique # for each row. 2.Source- which differentiate which data belongs to table A and Table B eg : Union ALL both tabel A & B final o/p shall be : ID| Product| Class| Source 1 |AAA | C | table A 2 |ABC | D | table A 3 |AAA | C |…
-
what to put in x, Y axis and series in Line +Grouped Bar ?
I am trying to display three simple values on this graph. need to see Forcasted value + Actual Value = Grouped Bar. Line - I want to see how many orders each month. So I did try to use this graph, it messed up all my data. I see values have been increased immensly. Please if someone can explain how I can dispaly these on…
-
How to add the unique numbers to every row of the output?
I have dataflow which consists of ETL o/p( table 1+Table 2) as i/p in sql. and further this I need to send it to another department, so they can fill in the blank fields. Thy will be able to fill in the blank fields only if I add the unique Key to each row of the o/p 1.I did add the Index of General type- looks like it did…
-
How to export the data from SQL data flow ?
I have created dataflow, and want to send it to another department to put their inputs, so how can I export the data from SQL dataflow ?
-
How can we display two values on x- axis?
I have a forcasted value, and actual value received every month. As Forcasted values are constant, like manual file uplaod which is decided by sales org in starting of the year. So How can I display the forcasted and actual revenue recived each month of the year. Which graph to be used, and how. Sample is attached. Where…
-
calculate exactly like Pivot tables in sql
Hello, I have sanpshot coming daily which gives the information of how and what sales we did for that day and it all formulates under ship to fiscal week, year , product, invoices, amount, etc. So what shall be my best approach to make it automated. I know we have distinct function in SQL which gives me quick win, so I…
-
First day of the week
Hello. I have an excel output which has data fed everyday. that contains all information about how many sales we made everyday. I would like to put on a dashboard that gives ne weekley information. So how can I code in magic ETL/ Beat Mode. So I can make my first day of the week as Sunday. eg: August 25th 2019 to August…
-
drag drop storytelling dashboard
How can we we drag and dashboard the cards in edit dashboard mode ?
-
% of kinds
I have X employees, in which I am trying to drill down each states employee is enrolled to some courses. So I am trying to find the percent of hw many courses an employee enrolled and how many are completed. Please tell me how? Thanks
-
Add Data to card
I need to add more data to the existing card. When I see the output of the chart for Q1 for 2017 in table. I look to add more fields to that graph. How does one do that ?
-
How to mask the data in workbench job ?
-
Workday Dataconnector
Hi, I am trying to use Workday dataconnector, so it asks me to provide the file/report URL. But I always had to selct the type of report, which gets downloaded in my local machine and then I use it. So not sure what options I have in this case? Thanks,
-
Pre Built Data Connector and Work Bench
Hi, Wanted to know is there any need of creating a work bench job when we have the pre built data connector? I ask this because I am trying to mask the data, there is Encrypt data option in work bench, trying to avoid redundancy. Best, Sanjana
-
How do we data mask in DOMO ?
I need to data mask some of the data that is coming from SFDC, successfactor. Do we have any automated function in domo we can do with ?
-
Vlookup/Related Function
Hello, I am working on a project that is combination of 3 excel coming from different servers. 1.Shall I define the data flow? if yes do we have vlookup functionality to combine the 3 excel report, do I need to define the mapping ? 2.Shall I upload the excel and then select the fields that I want from each excel What will…
-
How to setup SFTP Connection
Hello, I am trying to setup the SFTP connection, so one of the department can drop the file to the local DOMO server. But looks like it asks for the password. Which I am not sure how that works- is it the .Pem key/ Dataset id. It would be great if you could tell me how one you setup the SFTP Connection. Thanks,
-
Setting up SFTP
Hello, I am working on a project- which requires 3 reports. And 1 report has to be dropped by another department, and they can not do it directly to the network directory(DOMO Workbench). They are looking for SFTP credentials. Can anyone please help me in setting up this SFTP. Thanks
-
can we add Colors to SUMO card?
I have a sumo card created, and it has some calculations, which has range of percentage. And I have a threshold for certain percentage range like- 0%- green color. 1-50 % Yellow, 50-100% - Red color. I know we can see this in Card - Color properties. But is there a way we can do it in SUMO Card. As Business User is…
-
Vlookups in DOMO. How do we use Vlookup functionality in DOMO in Beast Mode ?
-
SUM, Percent
How to find the sum of two measures ? Eg : Created two fields in beast mode-> Old G/L = CASE 'Age in month' > 12 then Old Current G/L = CASE 'age in Month' >3 then Current . There fore, want to find the Total Entries= Old G/L +Current G/L secondly want to calculate percent of Old Entries = Count (Old G/L)/TotalEntries * 100
-
How to find the Difference between Months of two dates. Eg : 01/01/2017(start date) and Curdate.?