Best Of
Re: Listagg function or equivalent
You cannot Group_Concat in Beast Mode / Analyzer. You have to do this in SQL or Magic AFAIK
Re: Curved line + stacked vertical bar
the easiest way according to your screenshot is ....
for question 1 : you can move the series to the sorting options and sort desc , that way BGT will show up first then , B and A
for question 2: go to properties, general and type 2 in the "series on left scale" , this will make BGT and B be lines and A a bar.
Godiepi
Re: Curved line + stacked vertical bar
The curved line will use what is in the y-axis, so drag the field that you want as your first curved line into the y-axis field.
To add a second curved line, go to the Chart Properties - General and enter 2 in the Series on Left Scale property. Next, drag the field that you want as the 2nd curved line into the series and make sure it is the first item in the series.
Drag the field that you want as the bar into series, but make sure it is after the first item in the series that you wanted as the 2nd curved line. The card will use the 2nd item in the series as the bars.
Make sure to choose the appropriate aggregation type for each item that you drag into the y-axis and series
Re: Beast Mode
This is a BM I did for my summary number that does a similar thing.
case
when COUNT(DISTINCT `Feedback Type`) = 1 then CONCAT('Showing feedback for ' , `Feedback Type`)
else 'Please select feedback type to see accurate numbers'
end
In this case my user must select one Feedback type so I count how many there are and then display a message accordingly.
Ashleigh
Re: Beast Mode
@Fadem You can add something in your then clause so instead of just saying 'You are filtering correctly' you can say
concat('you are filtering correctly on ', `job`)
Ashleigh
Re: 2 editors for 1 etl in domo
Under the settings for the inputs you can check who has access by clicking share dataset
I believe can share will allow them to edit the dataflow using the datasets.
Ashleigh
Re: 2 editors for 1 etl in domo
@Emma yes, anyone can edit an ETL as long as they have access to all its inputs and have a role that allows them to edit dataflows.
Ashleigh
Re: Go to next page in List of Users?
Try adding offset to your parameter, such as:
offset=499&limit=500
Re: Lost ability to select a Date Range Field in Analyzer
@jcrouse I have also seen this before and it can be a little annoying. If it still won't unlock then just put the date field you want to use as the first column as that is the one that usually shows up for the date range.
Ashleigh
Re: Lost ability to select a Date Range Field in Analyzer
I have run into this before and I think the Analyzer just gets a little confused at times. I would try removing the field that it is currently tied to from your table list of columns and see if that unlocks it.
You have a lot of columns, but I think I have also just re-build the card from scratch to fix it as well.