-
Return the value based on the most recent matching the criaterion
Hi all, please help to resolve the following issue. I Have a very huge dataset showing the following and I need to fill the column "Currency 2/ USD" with values: # Time; Cur 1; Cur 2; Pair; Price; Currency 2/USD 1 2:00 pm EUR ; USD; EUR/USD 1,165 1 2 5:00 pm EUR ; USD; EUR/USD 1,167 1 3 5:01 pm UAH ; EUR; UAH/EUR 0,032…
-
Grouped Bar with Line Graph when series in multiple columns
Hi all, I know that the Grouped Bar with Line Graph requires one column for each of the "series", X axis, Y axis I have the following table: Date; Operation type; Operation amount; Rate 3/28/2018; Withdrawal; 1,000; 4% 3/29/2018; Deposit; 800; 3% What I have built is a grouped bar with shows the following: But I also want…
-
ETL to connect google analytics and SQL data with purchases
Hi all, Need your help in a following question: Our business is online retail. We track visits in google analytics and we track purchases on our site with accounting data stored in SQL server. What we want to see in domo is conversion rate: number of purchases per day / number of visitis per same day. First I think we need…
-
Average number
Hi, Please help. It should be easy but I can't find the solution. I have the following data: Date; Bank; Amount 10/29/17; Citi; $100 10/29/17; Citi; $200 10/29/17; Citi; $300 10/30/16; Citi; $1000 I need to calculate average daily amount for Citi Bank for the period 10/29/17-10/30/17. The calculation should be as follows;…
-
Average check amount
Hi all, I have the following data: Date Check amount 10/11/2017 $50 10/11/2017 $60 10/17/2017 $55 I need to build a graph showing average daily check so on a X asis I will have two dates: 10/11/2017 and 10/17/2017 with the values (50+60)/2 and 55 respectively. Please help
-
Projection value per category / Plan vs Actual
Hi Domo, I have the graph attached showing monthly expenses of the company in a form of stacked bar. When I add projection value it is same for each expense category. Is it possible to stated separate projection value to each category within last month? In case it is not possible, I want at least total per month to be…
