I'm trying to use a WITH clause as outlined here: https://dev.mysql.com/doc/refman/8.0/en/with.html in one of my MySQL dataflows. But I keep getting this error: "The database reported a syntax error. You have an error in your SQL syntax" My (very simple) code is: WITH test AS (SELECT`EmaiName` FROM transform_data_2) SELECT…
Is there any way we can delete all of the buzz conversations made to date?
In the page API documentation, you can get the page and page collection, but I don't see any option to retrieve card data. Is this possible? If so, how would I go about doing so?
1. If I embed a card from a page that has filtered the card, the embedded card does NOT retain the filter from the page even though it recognizes there is a filter. 2. Looking at the source code, I can look into the iframe and see how the filter is changing when I do change it manually. This is not what I want. Can I…
I have created a dataflow that doesn't show any issues until I save it. I see a message near the save button that says Saved but incomplete. Cannot be run until all actions result in an output. I can run the preview and see the data in the preview just fine. I can't for the life of me figure out what's throwing this error.…
Trying to see if this is even possible? At 4 pm all of my formulas break that use 'Current_Date' formula. I cannot utilize the Company Time Zone Settings since not all data sources we use are in UTC time already. Considering this limitation is there a way to accomplish this? Here is an example beastmode that I'm using that…
"Oops Something unexpected happened. Report issue." Hello, I have received the error above on a card that we use frequently. It was working one day and randomly stopped working the next. Any reason this might be? There has not been any change to the data to my knowledge. Possible bug? Thanks
I am using the Twitter Ads connector, pulling in the "Promoted Tweet Stats" report, breaking it down by day and then segmenting it by device (iOS). This report pulls in all of the necessary metrics, but there does not seem to be a "Spend" metric showing how much is spent ($) by day for each individual ad. Has anyone been…
ToDo: Use an Edit Data --> Replace Text action in the workflow. Select Regex option and replace by empty string. You can also replace the match with any string you require. Get Handles: (^|\s|[^@\w])+[^@\s]+ Example: Hi @Something how are @you doing David. Result: @Something @you Get Hastags: (^|\s|[^#\w])+[^#\s]+ Example:…
I have data based on quarter 1 and quarter 2. Can someone help me with the beast mode formula to display q1 and q2 values in summary number? Thank you
It looks like you're new here. Sign in or register to get started.