-
Table Card - show Top 10
How do I show the top 10 results based on sales. I can't remember where to enter "10" to restrict the number of rows shown in the table. thank you
-
Dataset with weeks as columns, need to pivot weeks into one column
Hi, How can i pivot a dataset which has the weeks as columns? I need to create one column with the weeks and the values within another column. This will enable me to provide charts more easily. thanks for any ideas! i'm sure it's within redshift functionality, but i'm stuck. thanks!
-
Sort Table by Field Count
Hi, I have a list of locations in one column with a list of attributes in the second column. I need to count the number of locations attributed to each attribute in a table chart. How can i create this simple result? I haven't had accurate results using COUNT functionality. thanks!
-
Does anyone have the Beast Mode with HTML code to include an up or down arrow into a card?
I need to create a header that displays some text (users don't always click on title for descriptions) . In order to have the beast mode availalbe to select as a header, it needs to have a calclation included. I was able to get it to work by adding sum(0+0), but 0 shows up in the text. I tried using IFNULL, but then…
-
Sumo card sizing
I have a SUMO card which is displayed in a larger card format on it's originating page. When it is added to a page managed by a publication group, it shows in the smaller standard card size. I have not seen this issue with chart cards, they appear in the larger format. Is this a known issue or am I missing something?…
-
Beast mode divide by zero error
Hi, I am stumped on a divide by zero error. I am calculating the weekly index by comparing weekly sales to the avg qtrly sales. Q3 and Q4 don't have results yet, so their value in the dataset is zero. How would I expand the case statement to correct for this error? Thanks!! Debbie case when `acct_wk_i` <= 13 then…
-
Convert text field to date format
I need to convert a text field to a date field. I have tried magic ETL which didn't work. I also created a redshift using a case statement "cast(week_end as DATE) as week_end" , which resulted in a sytax error "invalid operation: error converting text to date". any ideas?? Thanks!
-
Is it possible to have the x-axis label at the top of a Bar Chart?
I need the x-axis label to appear at the top of a Bar Chart so that it looks better in ppt. Is this even feasible? thanks!
-
Is it possible to have a Beast Mode result in a Date Formatted field type?
This is the beast mode formula, but it doesn't provide a field which can be used in the Date Range Field DATE_FORMAT(case when (`GREG_D` >= '2017-10-29' and `GREG_D`<= '2017-11-04') then '2017-11-04' when (`GREG_D` >= '2017-11-05' and `GREG_D`<= '2017-11-11') then '2017-11-11' when (`GREG_D` >= '2017-11-12' and `GREG_D`<=…
-
On a line + grouped bar chart, i can't get the week end date to reflect the date in the dataset.
The week end date is a Saturday within the dataset. In the chart, the week end date shows as a Sunday. Example 9/23/17 shows as 9/24/17. I can't remember which setting corrects this issue.
-
Is it possible to rename column headers in a SUMO card?
I need to rename column headers in a SUMO card? Is this possible? I saw a thread about this from 2016, but don't see anything further. Thanks!
-
Creating Percent of Total Bar Graphs
I have a bullet graph to measure Sales incomparision to Forecast. Is there a way to have the % to Fcst reflected on each of the bars in the graph?