-
How to calculate against row values, instead of a summation, when using a beast mode within a pivot
I'm currently using a simple beast mode within a pivot the table. The beast mode calculates the percentage change in the values from two columns. The issue is that, for subtotal and total, the beast mode is summing up all the percentage change values above it, therefore returning inaccurate values. Is there a way to…
-
How do you perform a calculation within a pivot table?
I have two rows on my pivot table—one for revenue and one for costs. Trying to get to profit. Is there a way to perform the profit calculation using a beast mode, and then making that beast mode a row? Picture attached for context. Thanks!
-
Is there a way to duplicate a value one row down?
I have a column with a numeric value and null value every other cell. I want to replace the null cells with the numeric value that is directly above it. Thanks in advance!
-
Is it possible to change the font on a dashboard's header?
-
How to use multiple summary numbers (from different dataflows) to calculate a final value?
On a single dashboard, I have 3 different cards, each of which pull from a different dataflow. Each card has a different summary number that I would like to use to calculate a final value on a Single Value card that I will place at the bottom of the dashboard. For context, the first summary number is revenue, the others…
-
What is the format for the substring function?
I'm looking for a breakdown of the conditions required for the substring functions. Thanks!
-
Card not reflecting updated Dataset/Dataflow updates
I manually run the input dataset that feeds into the datasets of 3 other dataflows. And all 3 dataflows reflect the inclusion of new data, but this is not reflected in the cards' visualization, as in the cards are reflecting data from the previous update despite the dataflows reflecting data from the new update. Any ideas…
-
How to create a stacked bar chart?
I am trying to create a stacked bar chart, but cannot find the option for it on Chart Types panel.
-
What function will help me determine a variable part of text?
I'm using Magic ETL to create a new column that will return True or False depending on the contents of a string in another column. Question is how do I write a Case formula that will return True or False based on the contents of another column? For example, the word "Delivery" is placed in different locations on a string…
-
Calculating a final value from other selected values that exist in the same column
I have two columns—one column has revenue, the other column states which quarter the revenue was collected in. Is there a way that allows a user to select a quarter to calculate the difference in revenue between the selected quarter and another selected quarter. So, I am basically looking for a solution that would enable…
-
Calculating a final value from two selected values that exist in the same column?
I have two columns—one column has revenue, the other column states which quarter the revenue was collected in. Is there a way that allows a user to select a quarter to calculate the difference in revenue between the selected quarter and another selected quarter. So, I am basically looking for a solution that would enable…
