Hello Sir, i fail to understand what you meant in your past reply,   I hope the information i have provided can help you understand my situation better,     I intend to make a butterfly graph   As shown in the graph above, i require 1 category and 2 measure data types. I already have the category data prepared. I am however, having problems with the measure data. Within the occupancy measure data, there are 2 values as shown below. (Im am using category data for show/reference)   My question is that since occupancy is classified as a measure data type how do i separate the values 0,1 and the data into 2 different varibables. (below is a screen short of the intended outcome)   As mentioned not occupies will only have the zeros and occupied will only have ones   I apologize for the repeated question Mr Fredrick. I appreciate any and all the help that you have given me   Regards Dan       ... View more

I apologize for the vagueness of the question.   As with the previous question, i want to separate the values (0,1) into 2 different categories. However, now instead of occupancy being a category type, it is now a measure type.   Will separating the values 0 and 1 be possible for occupancy with the data type of measure   Once again i apologize for any troubles caused.   Regards Dan ... View more

Hello Mr Fredrik, thank you for your reply. I have a follow-up question. Can the same method be used if the data type is now a measure as compared to it previously being a category type? ... View more

Hello and thank you for the reply,   I am unable to create calculated measures, the only option was for me to create a new aggregated measure. When brought to the formula screen, i dragged the boolean IF/ELSE statement to the workspace and dragged the category in. After it got dragged in, i got thrown an errror saying wrong type assigned.   These 2 screenshots are the options that are displayed, as i mentioned, there is no option to create aggregated measures   If I cant create calculated measures, what should be my next step? Do i have to ensure that the data thatt gets loaded into VA must be of the proper values? Does VA allow flexible type conversion?   Regards ... View more

Hello, i thank you for the reply,   I am required to create some dashboards for the client. The dashboards will give an over view about room usage :     I inted to separate the occupance data into 2 different variables, occupied and non occupied. At the same time, i would like to find a way on how to convert the category datatype to measure to enable the be variables to be placed in the measure (y) axis of the graph above.     I apologize for any troubles caused   Regards Dan  ... View more

Hello. I would like to apologize for being unclear with my message,   I have an occupancy column with 2 values, 0, 1. I would like to know if there is a way to separate the values into a column each eg: Unoccupied = 0 Occupied =1   I have tried using substrings, filters and creating new categories to manipulate the 2 values but to no avail. At the same time, a side question, is changing the datatype of category to measure possible?   Regards Dan  ... View more