Forum Discussion
love
Helper I
Helper IDisplaying progress as percentage for various datasets within one query
Hello. I face the following challenge: I would like to visualize progress in % per milestone. So, for example, I'd like to visualize 100% for Milestone1, 60% for MS2 and 20% for MS3. ...
Make some measures, one just being Measure1 = countrows(yourtablename), another being True = calculate([measure1], Completed? = "TRUE"), and a final one that's just PercentageDone = [True]/[Measure1]
jthomson
Solution Sage
Solution SageI might have got the syntax wrong and/or misread how your data is stored, perhaps try using Completed? = TRUE() instead
loveHelper I
Helper IMy query was reading the TRUE/FALSE as logical expression which I was not able to compare with the text (milestone column).
MilestoneName", type text}, {"Completed?", type logical}})I changed this to type text after which everything worked fine:
MilestoneName", type text}, {"Completed?", type text}})Thank you for your help jthomson.