chetan_cricut Member

@pauljames If you are referring to using the beast modes, then I am not sure which one can solve this?

@MarkSnodgrass the 'response_value' column is a string value. There are 100s of string values in that column.

@MarkSnodgrass sorry for the delayed resonse, however this doesnt seem to be working.

@MarkSnodgrass Thanks for explainig. Somehow I am not getting the required result. Unable to see the change

GrantSmith How can you drag two beast mode for current -3 and current-4? Also, I did not understand which chart type you were referring to. Can you pls share a snippet?

Thanks @GrantSmith I was able to use a beast mode and do partition by to get the desired results.

@MichelleH I have a line + bar chart which does not have a summary number, even if there is a summary number then it would only be for a specific metric. Now when we create alerts, it will only pick the summary number which is being used in the card for that specific metric.

@MichelleH even though this might seem like a solution, this would require multiple addtional cards being created since I am trying to track weekly % change on various cards, and each card has 2-3 metrics. Is there a better alternative to this?

@MichelleH The comparison should be sum(current_week) vs sum(previous_week) by x% However, I see an option to trigger an alert for sum(all_time_data) by x%

@MichelleH just to clarify I currently have 2 beast modes. The one on the left has multi select option(multi select is required for business use). I want to add the 'All' option to be part of the slicer on the left with a feature to include all 7 cases. Here is the beast mode I have used for ‘All’ case when combination in…

@MichelleH yes, but when we create 'All' option how does domo understand if all 7 needs to be accounted? Below is what I have managed to create, beast mode on left and control variable on the right. Not sure how this would function though.

@MichelleH how does this help me get the 8th variable with all 7 values?

Thanks @Sayyed007 that worked!

@Sayyed007 Can you please share a snippet where this "Show as filter" option is there. I am unable to find it.

Any luck here @GrantSmith ?

for every date of daily

Thanks @GrantSmith however, this will only give me a value when date is 30th Jan. How can I divide other dates with 30th Jan?

@MichelleH Thanks, that worked!!

@MichelleH I already did that, but I would rather want to show the date range instead of start/end of week. Do you know of a work around here?

Sorry, I dont see that. Can you please share a snippet.

There is another issue arring here of the duplicate dates on X axis. How can I overcome this issue?

@GrantSmith Thanks for the solution, this works. However, now when I proceed with the changes over the bar chart, the width size reduces. Attached old vs new case. How can I get the increase the bar width size?

MichelleH Thanks for the response. I think a beast mode like below is able to solve the problem, along with the options you have suggested. DATE_ADD(`date_id`, INTERVAL (8- DAYOFWEEK(`date_id`)) DAY)