Forum Discussion
RyanLMoran
Helper I
Helper ISum column based off of text data
Hello All: Quick question that I think will be relatively easy for sum. I'm pulling in some data and transformed that data to only show me courses that have the "First Grade" name in them. ...
serpiva64
Solution Sage
Solution SageHi, if you want something like this (i duplicated the rows only changing in Name the grade):
You can add column with extract
then
add a conditional column
Then on the cnvas you only need
As you see it is not necessary to create many query (one for each grade), the filter on ACTIVE can semplify but you can also gain the same result with a slicer in the canvas
If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !
RyanLMoranHelper I
Helper IThanks! I'll dive into this tonight, this looks to be along the lines of what I'm trying to get for output. And, you're right, it is more efficient than trying to create a query for each elementary grade