Percentage value not showing correctly in one of the series.....
Hi,
Need help with card building.
As you can see in below screenshot, there are 3 series of values which shows %rate. But the last one (conversion rate) is appearing as 100% which is actualy is in the range of 1-2%. I tried changing all formats (percentage, number, default... check box - divided by 100)
Best Answer
-
Try "ELSE 0"
SUM((CASE WHEN (`Segment Name` = 'Conversion Activities - Overall') THEN `Unique Visitors` ELSE 0 END )) / SUM((CASE WHEN (`Segment Name` = 'Overall') THEN `Unique Visitors` ELSE 0 END ))
0
Answers
-
Isn't null using an included column for the denominator by an arithmetic expression of BEAST MODE?
Won't a chart, but a table be 100%?
BEAST MODEの計算式で、分母にnullが含まれるカラムを利用していませんか?
また、グラフではなく表でも100%になりますか?
0 -
this is the beast mode which pulling conversion rate:
(SUM((CASE WHEN (`Segment Name` = 'Conversion Activities - Overall') THEN `Unique Visitors` END )) / SUM((CASE WHEN (`Segment Name` = 'Overall') THEN `Unique Visitors` END )))
0 -
I think that you have a misplaced parenthesis in your equation. Try this instead:
(SUM((CASE WHEN (`Segment Name` = 'Conversion Activities - Overall') THEN `Unique Visitors` END ))) / (SUM((CASE WHEN (`Segment Name` = 'Overall') THEN `Unique Visitors` END )))
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________0 -
Thanks Scott for digging... but this also didnt helped
0 -
Perhaps we need to look at the data to get a better picture of what is going on here. You have a column called `Segment Name` which contains the values "Conversion Activities - Overall" and "Overall".
In your equation, we search for the value "Conversion Activities - Overall" and when we find that we sum the `Unique Visitors` column. This tells us how many visitors fell into the "Conversion Activities - Overall" segment.
We then look at the same segment column for the value "Overall" and when we find that we sum the `Unique Visitors` column. In this case, I'm not sure that the divisor is really capturing all of the visitors from every segment.
Maybe try something like this?
(SUM((CASE WHEN (`Segment Name` = 'Conversion Activities - Overall') THEN `Unique Visitors` END )) / SUM(`Unique Visitors`)
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________0 -
I'm trying to achieve conversion rate for a particular page of a portal. To get this we divide conversion activity unique visitors by overall unique visitors of portal (achieving this by ETL data).
I successfully created 6-7 cards similar type for other pages with same beast mode applied, but not sure why in this card conversion rate coming as 100%. I want to remove extra 00% bcoz correct value are mostly 1% troughout the months (except 2% in one or two months). I checked in previous cards and nothing found any thing different, this is realy weird
0 -
can you look at a data table to check the values of those fields to make sure they are correct?
Or you could create a sumo card to check the sum of unique visitors when the segment is Overall and when it is a conversion.
It could be an issue with the data and not one with your beast mode.
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman
______________________________________________________________________________________________0
Categories
- 7.7K All Categories
- 12 Connect
- 925 Connectors
- 247 Workbench
- 441 Transform
- 1.7K Magic ETL
- 61 SQL DataFlows
- 456 Datasets
- 88 Visualize
- 222 Beast Mode
- 2.1K Charting
- 8 Variables
- 5 Automate
- 349 APIs & Domo Developer
- 85 Apps
- Workflows
- 17 Predict
- 3 Jupyter Workspaces
- 14 R & Python Tiles
- 242 Distribute
- 60 Domo Everywhere
- 241 Scheduled Reports
- 18 Manage
- 39 Governance & Security
- 46 Product Ideas
- 1.1K Ideas Exchange
- 6 Community Forums
- 19 Getting Started
- 6 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 577 日本支部