#Datorama0 discutindo

We are building a marketing dashboard that includes multiple companies, each associated with their total media spend by category (e.g., insurance, retail, etc.). We would like to rank these companies in order of their media spend within each category. 

Is it possible to create a custom dimension or calculated field in Datorama/Marketing Cloud Intelligence (MCI) to achieve this ranking? If so, could you advise on the best approach or provide guidance on the necessary steps? 

Thank you. 

**PLEASE COMMENT ON THIS POST WITH YOUR QUESTIONS**

Marketing Cloud Intelligence (Datorama) 2pm-3pm EST Thursday Session: 4/18

Register / Join here: https://cs.salesforce.com/events/7013y000002hjgPAAQ 

@Kyndell Mizell and I will be hosting our afternoon session today at 2pm EST. Please post your Marketing Cloud Intelligence (Datorama) best practice and strategy questions in this thread so we can go through them during the call. It will be first come first serve on this post. Speak with you all today!

Tips for asking the experts:

• Tactical questions best suited for a 5 minute conversation
• Best practice / strategy questions on Intelligence functionality and features
• Technical / troubleshooting error question? Contact Intelligence support by selecting the ? mark in the platform, then 'Contact Support'
• In need of more one-on-one help & training? Contact your Account Executive to discuss options
• #Datorama 

I know there is a LEFT and a RIGHT formula in the custom measures in dimensions, but I don't see a MID? I've seen extract, but I can't get it to perform the way I need it to. Is anyone familiar with a substitute for the MID function in Datorama

Hello, I am trying to make this kind of chart, bubble chart animated in Datorama, but I don't know if the platform support jquery

anyone know like I can make it

Has anyone experience with this field? I try to get from Facebook this value which is the revenue. When I use revenue from the conversion bucket in ads data stream I get values that are really high and make no sense. I tried the custom API but the columns are always empty I use the correct field based from the Facebook documentation.

I work for Regal Rexnord and have been made the owner of our Datorama tool and the company is willing to send me to school to get admin and advanced training. Since we are not a partner We do not have access to the partner academy.

Could anybody stir me in the right direction to get third-party vendor training? so far all I have been able to find that looks suitable is Decision Foundry. Any help will be greatly appreciated.

To give you an example of the tasks I need to do at present:

1. How do I delete data from Datorama stream?

From the Connect & Mix tab, select Granular Data Center, and then Delete Data.

2. Remove legacy fields from Data Set

3. Remove Dimensions that have to do with Account we removed in Remove Legacy Fields. 

I work for RegalRexnord and we have a growing salesforce division, since we are not a consultant, we are not part of the partner program and thus do not have access to the training offered there. We need to train up two of our admins in Datorama and voice, can anybody give me some leads on good sources for this training. 

@* Marketing Cloud Intelligence * 

Our MCI is new and we just started creating dashboards. We have data called Registration month which is the month the sales was made, this month is different from the month the lead was created. How do I make this Reg month not using the default Month / Month of Year in MCI.

Technical field available is Registration_date

So im using Datorama or trying to get it set up.

I have a simple report I want to report on it has three fields 

CreateDate

Lead Id

Lead Source

I just want to be able to report on leads that have been created on what day.

It doesn't pick up the CreateDate when trying to map this whatever formula I use in the formula PARSE_DATE, FORMATDATE, TO_DATE the formula is invalid