I have used an Excel sheet and imported into the easyBI. I have two columns of DateTime format. I need to calculate the difference between those two time slots and create an another column of the difference. But when I was trying to set the dimensions and measures for the dataset, I was getting error when I use both dimensions and measures for it. If i choose Dimensions for those two DateTime columns, it throws an error “There should be only one DateTime dimension”, later I have chosen dimension as timeline for both of them and given them different property names but it didn’t work as well. If I choose measures for both of them, it throws an error “Measures can only be Integers and Decimals.”
This is indeed common scenario in eazyBI. There can only be one Time dimension, but there is a way to import your date fields as measure and show them on timelines too.
If you are attempting to import these dates into your existing Issues Cube, I would assume they are tied to some dimensions/members that already exist in your eazyBI Data Cube. Let’s assume you are attempting two import two more dates for your existing epics
Here is a list of Epics for which I want to import two date fields “Date 1” and “Date 1”
This is how my mapping should look:
I am marking the Issuse Key column to be mapped to the Issue dimension, Issue level, and in the Advanced options (by clicking edit, I have marked that this is a Key column (because it is an issue key, and that the import should skip the missing lines)
Additionally, you will notice that I am mapping both Date Columns to the Issue column Issue level as well, because these Dates don’t necessarily belong to the Time dimension, but they rather are a property of my Epics that exist in the Issues dimension
But to tie these dates to the Time dimension, click on Edit and fill the information just like I’ve shown in the screenshot below. This is how eazyBI now understands that these dates should be imported as measures and tied to the Time dimension
Now you can use the Time dimension with these measures. You will notice in screenshot below that when I select the time Q4, eazyBI will return value 1 against measures “Issues with Date 1” and “Issues with Date 2” where it finds those dates in the particular time period.
