-
Filter to show blank cells?
Hey! I am looking to filter data to show columns that have empty cells. For example showing all results where 'Planning Condition Status' is blank. I had a look at doing a Beast mode formula but wasn't sure how to put 'Blank' in the formula? Is there an easier way for me to do this? Thankyou in advance.
-
UK map - google maps
Hi, I have a UK map which uses lat/long for the dots. I'm looking to use streetviews as that is our main way of identifying good sites remotely. Not all sites have streetview URL's so I can't rely on this. I was wondering if there is a google maps overlay or DDXBricks that can help me here?
-
Date Format change
I have a few columns which use the date format 01/Jan/2016, I need to convert these to 'Date' to use as date ranges in metrics. I have tried using the 'replace' text card in an ETL to change the forward slashes and months to numbers. This works on some rows but not all (trying to figure out why). Then I change the data…
-
Remove duplicate sites that have different 'operators'
Hello, I have a large list of sites where there are multiple duplicates of the same 'Site Address'. I can't just use the 'Remove Duplicates' tile in ETL as there can be multiple panels on one site. I'm looking to sort the sites using the 'Latest update' date field. Then I'd like to remove sites that have the same address…
-
Greater than current date
Hi, I'm working on a beast mode that groups sites into four buckets (Digitisation, Acquisition, Portfolio, Buy Out'. The last 3 are working fine and I just need to setup the formula for 'Digitisation'. The logic for Digitisation needs to be 'if Contractor completion is greater than or equal to CurrentDate then…
-
Check if site exists in another dataset, then remove from list if exists - ETL
Hi, I have a list of sites which have been joined from two datasets in an ETL using a field called 'Database Number'. This is working as expected. I want to then check whether this 'Database Number' exists in dataset 3, if it does, it means that we are working on this deal and therefore don't need this included in the…
-
Concat summary numbers
Hi, I'm trying to use the CONCAT function to combine two calculations into one summary number. I want to put Sites = Count of Panels, Panels = Sum of Panels I have done the CONCAT function but it is multiplying the numbers together it seems, I must have missed something and wasn't sure what: CONCAT(COUNT(Panels),…
-
Domo Powerpoint - Powered by Domo
We are liking the Domo Powerpoint plugin as we can continue to use our Company colours, fonts etc. The issue we have is that each metric has 'Powered by Domo' on the bottom right, as we have quite a few metrics on some slides this becomes overkill for the presentation. Would it be possible to have a feature to…
-
Comparing year on year figures
Hi, I'm looking to compare yearly figures from ‘Contractor Completion’ from 2019-2023. We'd like to know the percentage change for YoY and comparison by month too. The flex table or line chart looks like a good way to show this. What would be the best way to do this?
-
Combine date columns
Is the below logic possible? If appeal determination date is blank, insert determination date, if not insert application determination date?
-
Success Rate %
To work out the success rate I need to (a) count number of rows where 'Status' column has 'Application Granted' and divide this by (b) count number of rows where there is a value in 'Determination Date' column. A / B = Success rate Any help would be much appreciated, cheers
-
Calculations using analyser or beast mode
Hi, I have figures from a dataset that I need to carry out calculations on (addition, subtract etc). In the attached, columns 'CAP' and 'ITB Not Built' use different filters to get the final number. All I need to do is add CAP and ITB Not Built together for each client. Pipeline is just these two figures put together.…
-
Map cropping out Scotland
Any idea why the map is cropping out Scotland? We don't have a pin in Scotland but we need to show the whole of the UK. I have disabled 'auto zoom to data' but it doesn't let me zoom out to show more
-
Line graph - two date ranges
Hi, I have two date ranges (Planning Determination Date & Appeal Determination date) that I'd like to display on a line chart. The Y axis will be from the same column. What would be the best way for me to do this? Attached is an example of what I'm looking to do.
-
Current date and before end of the month
I'm looking to work out the number of remaining installations left in the current month. I have two columns which have date values (KPI Completed, Completed Awaiting Power). How would I show data that is greater than or equal to the current date and less than or equal to the end of the current month? Cheers
-
Gauge Series
Is it possible to use two different groups on a Gauge chart? I have 1 number but the number is put together using two different groups (series). A few people asked this question a few years ago but I was wondering if this has been added into Domo?
-
Success rate calculation
I'm trying to work out the success rate of applications submitted, attached is a basic flow diagram of how this calculation works. I have setup an ETL which filters out any withdrawn applications and separates the approved and refused applications. Is there a way that I can sum the values of Approved Applications and…
-
Combining data into one pie chart
I'm looking to combine data from 6 sources into one pie chart. All data will be coming from Pipedrive but each dataset uses different filters. I have setup an ETL which goes through each filter, I'm stuck on working out how to combine the data into two columns (stage and number of panels). Is there an optimal way to…
-
Difference between dates
I'm looking to work out the average time in days from 'Instructed' to 'Completed' (both dates), I'm using DateDiff but the returned value is -151 for some reason. Is there something I am doing wrong with this formula?
-
Calculated Fields - Pipedrive ID's
Hi, I am pulling in data from Pipedrive and need to use Calculated Fields to convert Pipedrive Field ID's into text. Is there a way that I can do this once instead of doing calculated fields for each metric?
-
Adding values from two datasets
Hi, I'm looking to add values from two datasets into one value. One dataset is Completed panels in 2022, the other dataset is Completed awaiting power in 2022. What is the best way for me to do this?
-
UK maps - long/lat
I'm looking to setup a UK map which shows the location of each site around the UK using long/lat, is there a specific way that I need to format the long/lat numbers as no data is showing with the data that I currently have? Thankyou
-
Increase timeout time to connect to API - JSON No Code Connector
I'm looking to connect to an API using the JSON No Code connector, the api takes about 40-80 seconds to generate the data. Is there a way that I can increase the timeout time in order to pull the data through?
-
Comparing two datasets for missing sites
Hi, I'm looking to compare two datasets from Smartsheet to identify which sites are missing from one dataset. For example, show me all sites that are in 'Master Schedule' but aren't on 'Secondary Schedule', both sheets have identifying numbers in column 'URN'. What would be the best way for me to do this? Would I join…
