-
Concat Summary # Issues
I'm having challenges getting my custom summary # to populate correctly. Below is my calculation, removed secure info with xxxxx. The formula is valid, but I'm just getting a result of 0 on my summary # without text or calculation. What am I doing wrong? CONCAT(avg (CASE WHEN `Offering Class Number` = 'xxxxxx' AND `Dim -…
-
Can you create a Summary Number that shows a subtotal percentage?
Good afternoon, Is there a way to create a Summary Number that shows what percentage a subtotal represents? For example, if I have a table that is showing 10 rows out of 1,500 rows, and those 10 rows equal 20% of my sales for the month, how can I create a Summary Number that shows 20%? THanks!
-
Can I show a percentage of a Summary Number underneath the Summary Number?
Good morning, Is there a way to display a percentage of the whole Summary Number, underneath the summary number? For example, in the screenshot below, would I be able to display that 20% of Total Streams (the 8.7M number) came from Paid users? Thanks!
-
How to show a count of rows from a table chart type as the summary number?
I have a dataset with a list of clients, the site they are listed on, and the count of the articles they've posted (aggregated in the card). I would like to show a summary number that is the count of the number of clients (which is also the count of the number of rows in the table chart). Is this possibe?
-
Modifying a Summary Number
I have a column in my data sheet with values like 0.202321. I display the AVERAGE of those values but when I select the NUMBER FORMAT as PERCENTAGE in the SUMMARY NUMBER, I get something like 20.2% when in fact the percentage should looke like 0.20%. How would you go about transforming these values? One idea I had was…
-
Dashboard not displaying Zero Sum results
I've built a dashboard for a variety of Adwords and Bing Ad results, and everything is working smoothly besides when I filter specific timeframes and the summation is zero, wherein it doesn't display anything in the Single Value field. I've created the following piece of code to try to mediate the issue and it doesn't seem…
-
User defined functions for Beast Mode?
Is it possible to create user defined functions that can be called in Beast Mode? I'm creating Beast Modes for summaries in the top left of a visual, and it's getting ridiculous & unwieldy pretty quickly. In order for it to look reasonable, I need to format and abbreviate the numbers, similar to how it's described in this…
-
Is it possible to have a text value in the summary number field? (e.g employee with highest sales?)
I know that it is possible to concatenate certain values in the summary number field, and use HTML to change colour. However is it possible to have a straightforward string, dependent upon values in the view? For example, the name of the employee with the highest level of sales over the past year? I hope that this makes…
-
How to remove the summary bar in waterfall graph or move it to the beginning of the flow?
Hi, is there an option to remove the summary bar from the waterfall graph? As an alternative, I am looking to move the summary bar to the beginning of the flow instead it showing up at the end. Thank you!