re: Joining multiple visual report table to calculate the sum
Hello Community, I have multiple tables giving information like business unit code, payer type, region. The objective is to calculate the estimate revenue coming from each unit by different payer. So from table we are calculating average per day revenue from each payer "Insurance" at specific Business unit "SN000". We have taken total SUM of the revenue and divided by total day categorizing average pay based on Business unit code and payer type. From another sheet. we have service. we are pulling data like service date and number of patient served on that day. Which is also categorize by Business Unit and Payer type. I had to create seprate table because when I'm trying to put all this information in average rate estimation it will create total patient number instead of giving result like one above telling number of patient on specific date, BU, and payer. We are trying to multiply Number of patient * Average pay to calculate total for each to calculate rough cash inflow from different unit. How can I multiply two seprate design by using table visualition to calculate each day revenue based on different categories. Final objective is to get something like this Is their away I can do setup this table like the above one ? id there anyway we can automize the above report to gather this census number everyday for particuliar day and calculate the total of that days and for all days days combineEasy Filtering
In my data lets say I have values from 1 to 52 representing weeks. If I click 4 I will get the data from week 4, but if I want to get the data from week 1 to week 4 I have to click every number in the slicer. Is there any way to automatically select say if I want to know values from the first 20 weeks, for it to automatically select 1 through 20?Postgre SDL Databes automatic refresh - Manage Gateway
I have a Postgre SQL database in AWS. I am trying to automatize the refresh process to do it automatically once per day. I have downloaded and connected the Data Gateway. I have downloaded and installed Baltimore Certificate in my Computer. Then I go to settings and Manage gateways and add a New Data Source. I complete all the Data Source Setting (Data Source Name, Data Source Type, Server, Database, Username, Password and Advance Settings as None). Also I have completed the data related to users. When I click “Apply” I receive the following error related to a not valid remote certificate following the validation process.
