
u/datawazo

Already Voted? Don't know what to do now? Sit back in Reminisce with the 2021 Municipal election results maps.
datawazo.com/municipal I realize that this hit's such a niche interest level but I am who I am and I do what I do.
Mothers day 10k
Like a good husband I abandoned my household on mother's day to go pursue my own frivolous endeavors.
Despite the rain my wife and kid came to cheer me across the line. Big up on them for that.
Started running last May after 8 years off. A humbling experience to try and get back into it, putting my 1st 5k down in 34 minutes.
Goal today was sub 50 and I not only got it, I out ran all my 10k efforts in the past year.
Was fun to do a race day again, especially sticking with a pace bunny early to make sure I didn't crash out early like I do in most of my training runs.
Just want to preface with I've done my research, I have my little matrix with pros and cons to present, just want to see if anyone has additional boots on the ground advice.
I have a client implementation on Tableau right now for head office. They like it, we like them.
They're a professional membership org, think like andvocacy/lobby group for family doctors. ~400 active members.
They want a subset of our reports available to all members, knowing that true uptake will be about 10% of users weekly, maybe 60% quarterly.
Standard user based pricing kills this model.
Tableau has consumption based but according to my internet sleuthing we'd be looking at about $28k annually.
PowerBI comes in at about $11k but you need to turn it off over night (?) and manage some type of tokenization which doesn't scare me but sounds complex.
I'd love to go with looker studio but we require login driven security.
So... I have two somewhat less mainstream options on my list that claim to work, with ball park estimates (wont name cause dont want to sound promotional) but wondering if anyone has experience deploying a solve for this within your projects?
No sales plz.
Stupid story but client sent me an excel proving my math was wrong in pbi.
The excel was a straight export of my matrix and highlighted the undeniable fact that my numerator of 1 divided by my denominator of 6 did not equal my percentage score of 7.8%.
Valid.
So I opened er up and double checked the dax for my numerator. Looked fine. Checked the dax for my denominator. Looked fine. Checked the quotient, no problem.
Maybe a relationship?? No. Maybe pulling something accidentally in from the wrong table?
I was going insane. Everything was lining up. Nothing about my math seemed off, but despite how many times I put the numbers in the calculator I just could not get 7.8%. The math didn't change.
I don't know what finally made it click, but I Checked the number format. Added a decimal. 1 was actually 0.5. 6 was 6.4. 0.5/6.4 does, in fact, math out.
Stupid formatting. Stupid morning.