Comments
-
See screenshot attachment for desired graph. We are counting the number of events that occurred multiple times in a given period. Look at sample data for Dec-18. There are 15 instances of specific events that occurred multiple times in Dec 2018. My Best Mode assigns a 1 in the data table column for these multiple events or…
-
We want to show the measure as 2 on the graph, just for X & Y. We don't want to show how many times each multiple event occurred. Just that events X & Y each happened more than once. (CASE When (Count(`Event`)) > 1 then 1 else NULLIF(0,0) END) My original beast mode sets the measure to 1 if an event happens more than once…
-
But it sounds like you understand the request. The only modification from your reply is that we don't want to see the events that happened only one time
-
Unfortunately I wasn't able to view the screenshot. I received an error.
-
Date Event 1/1/2019 x 1/4/2019 x 1/9/2019 x 1/2/2019 y 1/5/2019 y 1/10/2019 y 12/30/2018 z 1/11/2019 z I modified your sample data to set one of the Z records to 2018. In the following scenario, a date filter of All Time would summarize the beast mode as 3 since events X, Y, and Z each happened multiple times during the…
-
I'm trying to use a bar chart to display the data. I think summing my beast mode would make the calculation work, but I can't get the syntax to work. Here is my attempt at the beast mode. Can you advise how to get the summary count based on a beast mode to work? Sum ( -- Start Beast mode comment (CASE When (Count(`Event`))…
-
Hi: I tried creating an ETL but it only works when selecting all time as the date range. I added my ETL in the previous post. The ETL processes all data and determines if there are more than one occurance of an event. If yes, the event is summarized and then available in the output. As an example, event Z happened in 2016…
