Please check the attached and screenshot. Looking into the nature of your data, I pivoted all your measures into one Dimension as Date, converted datatype to and used it. Now, when you get new data. just bring it in this attached sheet as new source, pivot it and replace it. You would get the 0 count. So Steps I did:
- Pivoted your measures
- Got a Dimension as Date
- Got a measure as Value
- Created this LOD
Dragged it to Filter and Selected 1. Also Dragged it to Label and set Measure to COUNT. That's it. So next time you get your data set. Do Following:
- Pivot your measures
- Get the Date and Value Fields. I renamed Pivot Field Names to Date and Changed data type to Date. For Value Field, Rename the Pivot Field Values as Value.
- Replace your previous data source with this one.
Hope it Helps!!!
Non Comm and Down Time.twbx 890.2 KB
Thanks for the explanation Deepak and your help. I was able to get this to work!
Glad it worked. Can you take a moment to close thread by marking it CORRECT
So I went ahead and got everything to work for one day. However, when I tried to add a new data source (in the same format - with one incremental date added - I had to do the following:
- transform (all columns listed as dates)-> pivot
- change the dimension "Date" to data type "Date"
When I follow this step, I get errors. I have two questions
- why do I have errors? "Latest Date is invalid"
- How can I set this data source up to automatically Pivot the data and refresh the calculation? Each day, I expect to have new data.
I have attached the workbook with an incremental data source attached.