1 of 1 people found this helpful
Hello Faiz MH
I think this is happening because of the shape of the data.
What I mean by this is the empty cells you are trying to find with the ISNULL calculation won't work because there is no data to assign 'orange' to.
In your data set, every row has a value.
If you would like to encode/colour data which is not there with a calculation, you will need to create a dummy field for these, for example adding rows for each combination that doesn't have data:
CANAIR; NULL; NULL; SYSTEST4; NULL
I have recreated (I think) what you are after by editing the raw data and changing the calculation to include references now in the raw data.
Attached is the workbook but also the excel file with the new rows highlighted yellow.
I hope this helps,
Hi Alison and Venkatram,
Thank you for your reply.
The raw data(not real) that I had is actually from a database and it's LIVE data. I have difficulty of figuring how to construct the plot and dashboard based on that because as mentioned, every row has a value and the problem in this case remained with for instance for product Dubai Air, FinAir, Malindo, etc did not go through Systest1. It's similar case of Systest4 as well. Is there any way I can do this(to get below result) from live/extract data? Or is it possible to probably auto create dummy field on this dataset.
With the excel from Alison and method recommended by Venkatram, I am able to get the desired plot as below:
Still not sure about the difference between "No Data" and Not Tested".
Only the difference I see is SYSTEST1 has data or not.
So the expected formula is like this?
TESTDATA_7nov_SM_18.1.twbx 33.8 KB
It works!! Many thanks.
The "NoData" actually referring to no test data available for a certain product while the "Not Tested" is whereby certain products is not subjected to the test for example in this case SysTest1. I just read an old post(by Zhouyi Zhang) and realised that in my case, for the "Not Tested" category, there is no raw data populated and it's just that when we drag the Product and Parametric field, we noticed it as if there is row of data. I guess this is what Alison trying by including the dummy field.
It's a good learning experience from you guys. Again, thanks a lot!!
Glad that I cold help.