Best Of
Re: Google Analytics session data showing improperly
Sure!
When I say 'simplify' I mean pick as few "Dimensions" as possible. Here is a screenshot of the selected dimensions for a Google Analytics connector:
Google Analytics Connector
There are 3 Dimensions selected.
- Date: like 1/1/2019
- Medium: organic/social/referral/etc...
- Source: website where they clicked the link to come to my website.
This means that in order to use the user/session values I need to display a card that shows the Sum() By Day and separates the values for Medium AND Source without combining the numbers for them.
To Simplify By Day:
If I just want to see the User/Session totals by day then I need to remove the Medium and Source dimensions from the setup. If my only dimension is Date then I will get ONE row of data per day and the Users/Sessions will match Google Analytics.
Note: per Google's terms/conditions, sampling may apply. You can tell if sampling was applied by checking for a column in the dataset named: `Sampled Data`
n8isjack
Re: Color rules not working with bar + line chart
The bar + line requires you to have everything as an aggregation. You would need to create a beast mode for each partner name and what value you want to aggregate. You would then go to your color rules and select that beast mode name and assign it a color.
Re: DomoPhoenix.CHART_TYPE.RADIAL - When minimum value is 0.
I was able to get it to show a zero, but the value was 0.0000001
It does seem like this should be a toggle to force show the zero value.
Re: Number Format issues at dashboard/instance level
@Gionniz This can be achieved within company settings.
Although it would be nice to be able to choose the language and number format independently as we have users for example n Greece that isn't on the list but require European number formatting. They are happy to view the system in English just need the number formatting changed.
Jones01
Re: Way to Use Window Function to Find the Duration a Temperature Variable was Above a Threshold
i may be missing something here, but I don’t think think I window function is needed.
create a variable for the temperature threshold.
Min temperature:
Min(case when ‘temperature’>=variable then ‘temperature’ end)
Do something similar for max.
min time:
Min(case when ‘temperature’>=variable then ‘time stamp’ end)
Then graph by identifier
Re: How can I change the order of columns in chart?
Create a new beast mode to return an integer based on the order and then use that in the sort of the card:
CASE WHEN `Year of Tour` = '5 Years Ago' THEN 3 WHEN `Year of Tour` = '3 Years Ago' THEN 2 WHEN `Year of Tour` = 'Current' THEN 1 END
Excited to be here!
Just wanted to pop in and say I'm excited to be a part of the community forums! My company implemented Domo last year and we love it. 😁😎
Re: Does anyone know a Regex that only accepts a segment with a number before 'k' and nothing after?
Not too good with regex but how about this 2 step process?
michiko
