Comments
-
Okay that makes sense. it works when I don't use the series because I'm not excluding the denominator from the single whole, but once I put them into buckets, the denominator becomes separated from the numerator, or something like that, i think?
-
Good morning So now I'm having an issue with one of my beastmodes that I cannot quite figure out, and looking at the data table (SS2) seems like it should be working. The issue comes into play when I add a series. The concept of the beastmode is taking the distinct count of HC_donor_call_outcomes.id and dividing it by the…
-
Thanks everyone for the input. In the end I decided to go with the append Mark suggested because, like jaeW says, I like the visibility, especially for future trouble shooting. I ended up un-aggregating all of the other tables as well, with the exception of login hours per day, and used "staff" and "date" as a common…
-
Thanks guys, I'll try it out
-
Thanks, this was helpful. I did try_cast [column] as float between 9.5 and 11.99 and it is working now First i tried to do it as numeric but for some reason it would include 12.0-12.2 in the return
-
Thanks both for the feedback I tried Grant's first just because he responded first and it was more similar to what I had already started. Grant, I was able to get it where I needed based on what you explained. The only thing I did differently was, after the rank and window, instead of the group by, I pivoted back and made…
-
Sorry for the delay, I usually get email notifications when someone responds to my Dojo question, but I didn't this time, so I assumed no one had responded yet. I will work with this info and follow up thanks
-
Nevermind, I was able to figure this out.
-
Okay, thanks for the feedback!
-
I see that this post is from 2017 so maybe this was not an existing feature at that time or maybe you have since figured it out But in the chart properties within the anaylzer, under the data label settings pleat, if you select a data label setting value, it will then give you the option to pick a text color, and white is…
-
sorry, I provided the wrong beastmode. count is used in replace of rank, the first word in my beastmode above
-
Thanks for your suggestion, this worked. It is odd to me that, even though this beastmode kept it as a text column instead of a number column, I was still able to put it in my Y axis. When I put my original beastmode (time dif of stop and start time) into my Y axis, I could only get a count. When I changed it to no…
-
Thank you this worked perfectly.
-
Not sure why only 1 of my attachments posted
-
For the portion count (distinct case when 'successful/unsuccessful' = 'successful' then 'draw id' end), it was giving the NULLs a count as well. So I modified your idea a bit to: case when (case when 'successful/unsuccessful' = 'successful' then 'draw id' end) is not Null then Count(Distinct case when…
-
Hey, I remember you from Domo in Chicago. And thanks, I will try that.
-
I am having the exact same problem.
-
I took another look to make sure I had a valid macro in use for my hover text setting. While doing thing, I think I figured out what I had wrong. Under "hover text settings," I had "Hover Format" set to "Percentage." I was thinking that hovering over the series in the legend would work the same as hovering over the graph…
-
Hello. I am also having a similar situation I am struggling to graph. Out of all the donors who gave blood "yesterday", I want to find what the average blood draw time is. My thought was to get time duration column as the Y axis and value measure. Then, for the X Axis, I would use the donation ID's column, and the line…