Forum Discussion
Create a chart showing a mark for each day
The formula below was used to create the "Flow Status" field (dimension) in Tableau.
IF [Flow Hours] = 24 THEN "Full Flow" ELSEIF [Flow Hours] > 0 THEN "Transition" ELSEIF [Flow Hours] = 0 THEN "Shut-in" ELSE "No Report" END
The Flow Status field was then placed on the marks card and colored red/yellow/green based on the result (Full Flow/Transition/Shut-in).
seems like you can month on x axis, what is on y axis
- jhauff770608 years ago
Advocate II
In Tableau:
The Prod Date is on the X axis (exact date, continuous).
The Well Name is on the Y Axis.
The Flow Status (Full Flow/Transition/Shut-in) is on the color mark.
Does Power BI support anything like this?
- jthomson8 years ago
Solution Sage
You might need a custom visual - scanning the options something like Heat Streams could work for you perhaps. Not sure whether this can be done out of the box
- parry2k8 years ago
Super User
not sure, but if you share sample data in excel thru google drive or so, will try it
- jhauff770608 years ago
Advocate II
Parr2k - Thanks for offering to help. An Excel spreadsheet with sample data can be found here.