Youcef Boubellouta Posted February 19, 2021 Share Posted February 19, 2021 Hello, I want to calculate the number of Asked misions and the number of completed missions based on multiple levels of dates (months, days, hours), knowing that : asked missions = number of missions grouping bythe creation date completed missions = number of missions grouping by the end mission date I want to plot a barchart with 2 bars which representasked missions andcompleted missions in the same time. the problem is when i try to add a barchart in spotfire, I select the creation date time as X axis, so when I do Count([mission number]) in the Y axis I couldn't do another time for the second bar because it will calculate the number of missions based on creation date. Link to comment Share on other sites More sharing options...
Fabian Duerr Posted February 20, 2021 Share Posted February 20, 2021 You could create a new data table with an unpivot transformation. (Please rename the columns 'category' and 'value' to something meaningful): And then make a bar chart where you filter out empty values in your 'value' column. Use the 'color by' option for data breakdown: Is this what you are looking for You can also go further with this new data table by plotting the running sum of created and closed missions. Please see the expression for the Y-Axis in the visualization title (I used a line chart here. But you can simply swithc to a bar chart as well): Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now