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…
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 thi…
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 …
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 no…
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.…
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 sy…
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' …
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.