Please post .twbx file.
I am sorry. Not able to understand anything from the image.
I'm making an assumption about your requirment as it's difficult to understand without an example file.
Do you have anything in the data that can be used to determine the "status" of a given part - ie, the number of time it's been used? Or is this purely determined by the date? If it's the former, it would be straightforward to create a calculated field for status, and drag that to the colour shelf to colour-code your view. If the latter, then it's potentially more complex as you'd need to create a calculation that determines the status from date, possibly at the "setup" level of detail - this may require LOD expressions, etc.
Could your perhaps supply a sample of data that's structured in the same way but doesn't contain any confidential info?
Hi, thank you,
There is nothing to determine the status of a part, this can only be determined by date, or by order of occurrence
I've added a table here of what the data looks like in the database.
As you can see, Setup 582, 599, and 603 all contain the same Parts (there are several more Parts per Setup).
The scatter plot shows how much each Setup has produced.
I'm gonna need to color code this so that I can see that Setups 582, 625, 687 etc all contain brand new parts that have not been part of an earlier Setup. Similarly, Setups with parts that are used for the second time, should have a different color.
Parts Setups Date Produced 1401 582 2018-01-01 235 000 1401 599 2018-01-03 365 000 1401 603 2018-01-06 268 000 1402 625 2018-01-12 214 000 1402 648 2018-01-18 329 000 1403 687 2018-01-24 319 000 1403 709 2018-01-30 267 000 1403 728 2018-02-05 331 000 1404 751 2018-02-11 297 000 1404 772 2018-02-17 263 000 1404 796 2018-02-23 342 000
Determining if the part has been used before based on the date is fairly straightforward (see attached). If you need to determine if it's specifically the second, third or nth time that's a bit trickier. Have a look at the attached - does that get you anywhere?
Book1.twbx 45.7 KB
This helps a lot! I modified the graph a bit, and the attached image shows basically what I want.
It would be great to display different colors for the n'th time a part is used. I think this would require a different approach to solving the problem though.
But this is still a good start and will be useful on its own.
No problem, glad to help. I guess the n'th challenge could be achieved by nesting LODs - in a sense, the min of the False set would be the second, the min of that the third, etc. to as many levels as you need.