-
Pivot table: Change Subtotal to Average
Hi everyone, I am facing a problem of presenting averages as the 'Subtotal' instead of the sum as subtotal in pivot table. The following picture is the context of this issue: The columns are working days and the rows are monthly data for shop 1,2,3…. The source data is daily data. However, for this table, each cell is…
-
Adjust Image size in Pivot Table
Hi everyone, I am facing a problem with adjusting image size by using HTML code in the Pivot table. What I want to achieve is: add an arrow indicator (arrow image, Domo API ) column at the end column of pivot table to indicate the direction of changes. However, when I adjust the size of my arrow image, the HTML code…
-
Execution order of AND/OR in case when statement
Hi everyone, I am really confused about what is the order of executing AND/OR in case when statement and whether brackets work. For example, what I want to achieve is: (A AND B ) OR (A AND C) which means that I will select rows that can satisfy either AB or AC conditions. (1) Question 1: Does brackets work if I have a case…
-
STR_TO_DATE
Hi everyone, I am facing a problem of transforming Text to Date type. I have a column called Date. The format looks like this: I used the following formula to transfer it to Date formate" STR_TO_DATE('Date','%d-%b-%y') but the following error message popped up. Could you please tell me what's wrong with my formula? Thank…
-
Bar chart projection feature
Hi everyone, I am using grouped bar chart to present actual and budget financial data and try to project the next 3 month's data. Please see the following chart as an example. I have the following question: Why it only projected Actual data but not budget data. The following is my multi-period projection properties if it…
-
How to add gross profit row into profit and loss pivot table
I am using pivot table to create a profit and loss statement. Please see the following picture: I want to add a row which is called Gross profit below TOTAL COST OF SALES. Gross profit is calculated by subtracting TOTAL COST OF SALES from TOTAL TRADING INCOME. Also, I don't want to create a Gross Profit account and join it…