Forum Discussion
how to do trend based on live data
Helper VIf you can connect to the datasource from it is simple as creating a line chart and setting up a OnPrem gateway to update data on a regular basis.
Whats the data source? Can you connect from Power BI Desktop? Do you have access to a Pro Licence?
Through Oracle.
I think I am unable to explain clearly. As the live data yesterday is not same as today's live data, I am unable to make a trend line.
- prihana
If you can get the data in below format
You can create below trend graph
Thank you for showing me this.
The challenge is to get data in that format.
As I mentioned I have live data on my Dashboard. The data that was yesterday is already gone and not recorded anywhere. I am unsure on how to record that in powerbi somehow.
E.g. Today's data says $10. Yesterday it was $15. I cant see the value $15 anymore as the data refreshes overnight.
Is there a way where I can record $15 from yesterday somewhhere in the data table so that I can then start making reports / charts.
Cheers
Abhi
Hi asodhani
I'm experiencing the same problem. I want to show a trend of the live data, but the live data keeps on changing daily.
Have you found a way of doing it? I need help to do this.
My situation: I have live data of open tickets for my team. Everyday, the amount of open tickets keeps changing but my manager wants to see a trend of how many open tickets there are each day. But the data is live, and there is no time stamp.