Hi, ineed help please. I'm super new in using Tableau. I'm using version 8.1. I have to create an intraday liquidity monitoring live dashboard where at the start of the day you need to see a straight line (forecast amount) through a time series of 07:00 to 17:00. This amount must already be populated at the start of the day. As the day progresses payments will start coming in (payment amount) and as that happens the forecast amount will change accordingly. I am using a cube as the data source. My problem is i need to fix the x-axis which is the 'Time' axis to be 07:00 to 17:00. When i rightclick on the Time dimension on the axis it doesn't allow me to click on the whole time but on a single value of time. I read somewhere that the time dimension has to be converted from discrete to continuous in order for me to be able to select the whole axis but i still didn't manage to do that.
Any help will be appreciated. Please find attached my workbook. The first sheet is where i need to do all that work.
Welcome to the Community! Unfortunately, we're unable to open your workbook with the data since you are using a cube. Would you be able to post a couple of screenshots or recreate what you're trying to do using an Excel data source (maybe Superstore would work)?
I have attached two images of how it looks like on a dashboard and on a sheet. The black line being the forecast line that already has to be populated at the beginning of the day, the grey line being the cumulative position which is the running total of payments. The green being the inflow payments and the red being the outflow payments. The time at the bottom is only showing from 07:04 to 16:56 on the dashboard but on the sheet i filtered it from 07:00 to 17:00. The requirement is for the time to be fixed (07:00 to 17:00). I also need to make the time in 15 minutes intervals instead of every minute because the inflow and outflow payments are not clear on the dashboard. I would prefer to have both graphs on the same axis as well. Thanks