Best Of
Re: ZIP code leading zeros being removed
If you can, import the data as a string instead of an integer.
Re: Scatter Chart
Hi @Raymond -
Welcome to the forum. I'll try to guide you through the basics, not knowing the structure of your dataset is or where you are getting stuck. Feel free to follow up with more questions if needed.
The scatter plot chart type is found in the "Data Science" collection:
Once selected, the fields at the top of the screen will allow you to build your chart. For Scatter charts, you are allowed to add "X AXIS", "Y AXIS", "SERIES", "BUBBLE SIZE".
You will likely need to create a calculated field to allow Domo to generate the profitability, unless that is already part of your data. If you need help with that, please share some more about your dataset. In particular what fields would be needed and how you calculate profitability.
Re: ZIP code leading zeros being removed
If you are unable to change how the data is coming in as @ST_-Superman-_ suggests, you can use the LPAD() function to add the leading zero, when necessary. You can do this in Analyzer by creating a beast mode, or in Magic ETL using the formula tile. It would look like this:
LPAD(zip,5,'0')
This will add a zero to the front of the string if it is less than 5 characters to make it 5 characters long.
Re: Is it possible to create a table showing appointment availability in Domo?
@lb1234 , I'm happy to try and help.
To block off the time instead of showing a count, you can use color rules. Using your example and blocking off where the cell has a 1 in it, you would:
- Go to the analyzer and click 'Colors' under properties or 'Color Rules' at the top (both go to the same place
- Pick 'Close Appointments Scheduled' as the column and the condition as 'Is' 1
- Click 'Auto' under fill to open up the color pallet and in the box at the bottom under the Opacity slide, type 000000 (hex code for black)
- Under Table Text, select the T all the way to the right and then uncheck the box next to 'Apply to row or column
- Click Next then 'Apply only to this card'
This won't wipe out the number completly but it will make it very faint. If you need it completly gone, let me know and I'll see if I can come up with some beast mode magic.
For the data piece:
Instead of the hours of the appointment, are you wanting to see every 15min incrament in that column on the table? So 6:00, 6:15, 6:30…? Depending on how this is being used, that's a lot of rows per day. If you can do with something less percise, you could count the number of appointments a person has per hour then use color coding to show if that hour is completely or only partial blocked. You wouldn't know which slot was booked, but you'd know if that closer had any available slots that hour. Beyond that, I would need to know more about the underlying data structre. Does each row have a name, date, Start Time, End time, appointment type…
If you can give me a little more information, I'll see if I can help with that.
Hope this helps at least a little bit!
Brian
bfentres
Re: How would I pull the highest rate over the last 12 months in a beastmode?
It's pretty difficult to tell where the error is here. I tend to try to break these complicated calculated fields up firts to make sure that I am getting the correct values for each "step". For example, make sure your numerator value is coming through correctly, then confirm the denominator value. Then put the whole thing together. That being said, you are doing a lot of aggregating here. Taking the Max of the Sum of the distinct count. Not sure how Domo will handle that. You could try this?
MAX(
SUM(
(COUNT(DISTINCT
CASE WHENTask.EventOutcome= 'Converted' ANDCreated Date>= DATE_SUB(CURDATE(), INTERVAL 365 DAY) THENTask.ActivityIDEND))) OVER (PARTITION BY MONTH(`Created Date`)) / SUM(COUNT(DISTINCT
CASE WHENCreated Date>= DATE_SUB(CURDATE(),INTERVAL 365 DAY) THENTask.ActivityIDEND ))
OVER (PARTITION BY MONTH(`Created Date`))
)
Re: Daniel Galley - SharkNinja
This is awesome. Thanks for being a member of our community!
