Join our Community in its new Home - The Datorama Trailblazer Community Group!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
COUNT & COUNTDISTINCT Functions help
JBell
UKACCOUNT_ADMIN 
in Help Center
Im trying to implement 2 use cases which require the capability to count the number of records in a table:
1st one: # of orders made based on a transaction log. This contains an 'Order ID' field and all the usual metrics like revenue etc. Ive tried to use COUNTDISTINCT in a few different ways, including using +[metric]-[Metric] but i simply cant get it to aggregate the total number of orders in the table!
2nd one: Similar scenario, but i want to count the number of Subscribers in some source data. There are no measurements in this table, only subscriber information such as 'Subscriber ID', 'Email address' (which has been MD5 hashed) and things like 'Created Date'
Any solutions/tips on where im going wrong? This should be a fairly simple calculated measurement to count the number of records, right?
1st one: # of orders made based on a transaction log. This contains an 'Order ID' field and all the usual metrics like revenue etc. Ive tried to use COUNTDISTINCT in a few different ways, including using +[metric]-[Metric] but i simply cant get it to aggregate the total number of orders in the table!
2nd one: Similar scenario, but i want to count the number of Subscribers in some source data. There are no measurements in this table, only subscriber information such as 'Subscriber ID', 'Email address' (which has been MD5 hashed) and things like 'Created Date'
Any solutions/tips on where im going wrong? This should be a fairly simple calculated measurement to count the number of records, right?
Answers
This would require a direct look. I would advise you to raise a ticket to our team at [email protected] (or directly through the platform). Our colleague will be glad to help and optimize your setup.
Have a great day!