mindbender Member

Could it be this somehow? The Value field is as follows COUNT(DISTINCT 'Booking ID') and the results are always 1s. If I remove that and replace it with just the booking Id field and an agregate of Count the numbers show but there are duplicate booking ids listed in the results. Any idea why the COUNT(DISTINCT 'Booking…

I tried that too and same result. Thanks for the help I will try rebuilding them from scratch

sorry attached wrong graphic in last post

I removed the rolling filter and chaged the criteria to the last 14 months and it still shows 1s. Very strange

The results stay the same - all 1s accross the board

and if I remove the count distinct and just show booking ID I see there is more than 1 booking ID by center in table view

I attached an image with the details. The Start Date field is daily then grouped by Month through the date filter and the other filters are shown on the image Thanks for the help

Thanks for the tip. I was able to see the changes that were made. Great insight.

I am not sure what is going on but I keep getting validation error. I have a list of about 2000 accounts that I am trying to query for. Maybe this isn;t the best way to go about it. What I am trying to do is match Company Name from my file to Compnay Name in the data and return fields limiting the data to those accounts.…

thank you dso much that helps

That is awesome. Thank you so much and thanks for the link to the documentation. iw ill read through that as well. I appreciate your help.

I have created the calulations and clicked the share to dataset checkbox and I see the 2 calculations listed under measurements. But I am not sure how to apply them or what you mean but to use them set value =1.

They woudl be used as the data parameters for several types of reports. I have attached 3 reports where the data woudl be exactly as it is on the charts - it would just be the dates it is filtered on that woudl be MTD-to prev week and Rolling 13 month Thanks for looking at this

thanks for the info. I would agree this is more of a defect that a feature.

Thank you very much for the help

thank you I appreciate it. So new to Domo. I will looking into Sildeshows.

that is awesome thank you.