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.” -Superman0 -
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.” -Superman0 -
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.” -Superman0 -
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
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive