Re:PostgreSQL 17
by bigger_cheese on Friday September 27, 2024 @01:50AM
(#41666679)
I'm sure it can work but I've found it hard to slot into our use cases.
Power BI's trending is one thing I have really struggled with the limitations it has.
For one of my use cases (industrial plant data) we often want to trend timeseries data on a common xaxis with uniquely scaled yaxis.
i.e Temperature, Pressure, Flow Rate, Fill height etc all have differently scaled yaxis but common xaxis.
Something like this example https://imgur.com/a/zd5Giom
Power BI limits you to a single primary and a single secondary Y axis only (i.e limit of two scales).
sorry weird question, did you keep changing this link?
was one of the link on powerbi.tips
can you put that back, for some reason my browser history lost it , or something weird happened, not sure what it is
Re:PostgreSQL 17
by bigger_cheese on Sunday September 29, 2024 @06:40PM
(#41691459)
I edited the link once to a graph that better illustrated what I meant both results came from a google image search.
DAX is supper powerful, if you design your datawarehouse as a proper stat scheme, there is nothing you cannot calculate using DAX
Nothing in the market is even close, most BI tool have magic expression language, DAX is a proper language