Hi Jeff. I tried to create a group on my calculated measure but I only get the calculated field option(see below).
I did manage to create a text measure, 'significant (copy)'. I put it in the row shelf. (see below). It works but I was hoping to have the text appear next to the Z score or the proportion, where the 'significant along table (down)' dimension is located.
I am trying to convert an existing excel document into tableau doing my best to keep all the same formatting.
I guess for whatever reason, you can't group on calculated fields
1 of 1 people found this helpful
You can nest calculations in other calculations, so if I'm reading the thread correctly, you could group the calculations using ANOTHER calculation.
Make sense or no? Anything is possible with Tableau!
To clarify, you can create Groups from calculated fields as long as they are row level (non aggregate) values, the problem in the screenshot above is that you're trying to group an Aggregate Measure, not a row level value. Screenshot below is an example, where the group is a group of dimension members--you can also do this with measures, so long as the measures as row level values, not aggregations.
Cheers and happy vizzing!
All that being said, its very difficult to help without seeing your work -- if you can mock up an example that is similar using Superstore Sales, or if you can randomize your workbook, attaching a TWBX to this thread along with a desired result/mockup is likely the best bet for gaining insights from volunteers on the Forums.
attached is a sample workbook.
Basically want to see if there is a way to get the "Significant" text at the end of the table rather than at the beginning (replace the "1" at the end with the table with "Significant")
Thanks for your help.