Mostrar un análisis de datos numéricos donde se re...

Bluewolf01 · ‎11-07-2019

Buenos días, tengo tres bases de datos en las cuales recojo información numérica de un equipo, es decir dimensiones luego tengo que analizar los datos recogidos es decir comparar datos, cierto campo de la base de datos uno y compararlo con otro campo ya sea la base de datos dos o tres, pero no se como puedo hacer ese análisis y mandarlo a mostrar en la app.

v-xida-msft · ‎11-07-2019

Hi @Bluewolf01 ,

Could you please share a bit more about your scenario?

Could you please show more detail about the data structure of your three tables?

Are there some relationship between the three tables?

If there are relationship between these three tables, you could consider combine your three table records into a single one collection based on the relatonships (using AddColumns function), then you could add Chart control into your app to display the records based on the combined collection.

More details about combining multiple tables within an app, please refer to the following thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Syntax-for-joining-tables/td-p/6138...

In addition, based on the needs that you mentioned, I think Power BI report may be a better choice for you. You could consider add your three tables as dataset into your Power BI desktop, then based on the three datasets, you could consider create a report using proper visual. Then you could publish your report to a Workspace in your Power BI server.

After that, you could go to your Power BI server, then pin the uploaded report into a proper Dashboard under the Workspace. Then you could go to your PowerApps app, add a Power BI tile control, to embed above Dashboard tile.

More details about creating Power BI report, please refer to the following article:

https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report

More details about the Power BI tile control, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Bluewolf01 · ‎11-08-2019

Te comparto lo que tengo para que puedas entender mejor; las tres base de datos tienen el mismo diseño.

Vsup10 " Se ingresa medidas de vista superior de molde"

Vinf10 " Se ingresas medidas de vista inferior de molde"

VZap10" Se ingresa medidas de zapatitos"

Tengo que comparar las medidas tomadas en Vsup10( superior D comparar con superior E la diferencia en valor absoluto tiene que ser menor o igual a 3) y asi sucesivamente para otros campos de la misma base de datos y sucesivamente para las demas base de datos.

en Vzap10 tengo que comparar con Vsup10 yt la diferencia de los campos tiene que ser menor o igual a dos.

Adjunto imágenes, espero me puedas entender mejor